Author: shawkins Date: 2010-10-29 13:30:50 -0400 (Fri, 29 Oct 2010) New Revision: 2690 Modified: trunk/build/kits/jboss-container/teiid-releasenotes.html trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml Log: TEIID-962 refinements to textagg. Modified: trunk/build/kits/jboss-container/teiid-releasenotes.html =================================================================== --- trunk/build/kits/jboss-container/teiid-releasenotes.html 2010-10-29 17:21:21 UTC (rev 2689) +++ trunk/build/kits/jboss-container/teiid-releasenotes.html 2010-10-29 17:30:50 UTC (rev 2690) @@ -42,9 +42,8 @@ <LI><B>Improved clustering support</B> - see the Admin Guide chapter on clustering. <LI><B>IPv6 support</B> - Teiid can started using IPv6 bind address and can be used with JDBC connection. <LI><B>SESSION_ID</B> - A new system function "SESSION_ID" is added to the system function library. - <LI><B>Assignment Syntax Improvements<B> - Teiid's procedure syntax for assignments was clarified so that the assignment value must be a proper expression. INSERT/UPDATE/DELETE update counts must be obtained from VARIABLES.ROWCOUNT, scalar values must be obtained via a scalar subquery. - <LI><B>TEXTAGG</B> - SQL support for Text aggregation. Using this function expression values can be aggregated into a single line of text with delimiter and header, that can be optionally saved to a text file. - The parser will continue to accept the old syntax and convert the query into the proper form. + <LI><B>Assignment Syntax Improvements<B> - Teiid's procedure syntax for assignments was clarified so that the assignment value must be a proper expression. INSERT/UPDATE/DELETE update counts must be obtained from VARIABLES.ROWCOUNT, scalar values must be obtained via a scalar subquery. The parser will continue to accept the old syntax and convert the query into the proper form. + <LI><B>TEXTAGG</B> - SQL support for Text aggregation. Using this function expression values can be aggregated into a CSV BLOB with configurable delimiter, header, and encoding. The result can be optionally saved to a text file. </UL> <h2><a name="Compatibility">Compatibility Issues</a></h2> 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-10-29 17:21:21 UTC (rev 2689) +++ trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-10-29 17:30:50 UTC (rev 2690) @@ -238,10 +238,12 @@ <para>STDDEV_SAMP(x) – sample standar deviation (excluding null) logically equals SQRT(VAR_SAMP(x))</para> </listitem> <listitem> - <para>TEXTAGG((expression [as name], ... [DELIMITER char] [QUOTE char] [HEADER] - <link linkend="orderby_clause">[ORDER BY ...]</link>) – Text concatination of all expressions in a group (excluding null). - When DELIMITER is not specified, by default comma(,) is used as delimiter. Use QUOTE, to quote the each expression value with - provided character. If HEADER is specified, the result contains the header row as first line. This aggregation returns a Clob. + <para>TEXTAGG(FOR (expression [as name], ... [DELIMITER char] [QUOTE char] [HEADER] [ENCODING id] + <link linkend="orderby_clause">[ORDER BY ...]</link>) – CSV text aggregation of all expressions in each row of a group. + When DELIMITER is not specified, by default comma(,) is used as delimiter. Double quotes(") is the default quote character. + Use QUOTE to specify a differnt value. All non-null values will be quoted. + If HEADER is specified, the result contains the header row as the first line - the header line will be present even if there are no rows in a group. + This aggregation returns a blob. </para> </listitem> <listitem>