Author: shawkins Date: 2010-05-18 16:59:49 -0400 (Tue, 18 May 2010) New Revision: 2141 Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml Log: TEIID-171 adding support for xmlagg Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml =================================================================== --- trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-05-18 20:54:34 UTC (rev 2140) +++ trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-05-18 20:59:49 UTC (rev 2141) @@ -220,6 +220,9 @@ <listitem> <para>MAX(expression) – maximum value in a group (excluding null)</para> </listitem> + <listitem> + <para>XMLAGG(xml expression <link linkend="orderby_clause">[ORDER BY ...]</link>) – xml concatination of all xml expressions in a group (excluding null)</para> + </listitem> </itemizedlist> <itemizedlist> <para>Syntax Rules: @@ -783,7 +786,7 @@ <sect2 id="orderby_clause"> <title>ORDER BY Clause</title> <para> - The ORDER BY clause specifies how the returned records from a SELECT should be sorted. The options are ASC (ascending) and DESC (descending). + The ORDER BY clause specifies how records should be sorted. The options are ASC (ascending) and DESC (descending). </para> <para> Usage: