Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 73573 invoked from network); 18 Mar 2008 12:51:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Mar 2008 12:51:09 -0000 Received: (qmail 17643 invoked by uid 500); 18 Mar 2008 12:51:07 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 17617 invoked by uid 500); 18 Mar 2008 12:51:07 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 17606 invoked by uid 99); 18 Mar 2008 12:51:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Mar 2008 05:51:07 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Mar 2008 12:50:37 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 8FCC21A9838; Tue, 18 Mar 2008 05:50:48 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r638353 - /db/derby/docs/trunk/src/ref/rrefsqlj33923.dita Date: Tue, 18 Mar 2008 12:50:47 -0000 To: derby-commits@db.apache.org From: rhillegas@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20080318125048.8FCC21A9838@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: rhillegas Date: Tue Mar 18 05:50:43 2008 New Revision: 638353 URL: http://svn.apache.org/viewvc?rev=638353&view=rev Log: DERBY-3550: Commit Kim's patch to the Reference Guide, removing the claim that Derby provides support for user-coded aggregates. Modified: db/derby/docs/trunk/src/ref/rrefsqlj33923.dita Modified: db/derby/docs/trunk/src/ref/rrefsqlj33923.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj33923.dita?rev=638353&r1=638352&r2=638353&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefsqlj33923.dita (original) +++ db/derby/docs/trunk/src/ref/rrefsqlj33923.dita Tue Mar 18 05:50:43 2008 @@ -27,8 +27,7 @@ other built-in functions operate on a single expression, aggregates operate on a set of values and reduce them to a single scalar value. Built-in aggregates can calculate the minimum, maximum, sum, count, and average of an expression -over a set of values as well as count rows. You can also create your own aggregates -to perform other set functions such as calculating the standard deviation.

+over a set of values as well as count rows.

Aggregatesand data typesThe built-in aggregates can operate on the data types shown in . Permitted Data Types for Built-in @@ -38,7 +37,7 @@ colwidth="20*"/> <thead> <row> -<entry colname="1"></entry> +<entry align="left" colname="1" valign="bottom">Function Name</entry> <entry align="left" colname="2" valign="bottom">All Types</entry> <entry align="left" colname="3" valign="bottom">Numeric Built-in Data Types</entry> </row> @@ -51,22 +50,22 @@ </row> <row> <entry colname="1">MIN</entry> -<entry colname="2"></entry> +<entry colname="2"> </entry> <entry colname="3">X</entry> </row> <row> <entry colname="1">MAX</entry> -<entry colname="2"></entry> +<entry colname="2"> </entry> <entry colname="3">X</entry> </row> <row> <entry colname="1">AVG</entry> -<entry colname="2"></entry> +<entry colname="2"> </entry> <entry colname="3">X</entry> </row> <row> <entry colname="1">SUM</entry> -<entry colname="2"></entry> +<entry colname="2"> </entry> <entry colname="3">X</entry> </row> </tbody> @@ -104,7 +103,8 @@ WHERE t2.y = SUM(t1.c3)) </b></codeblock></p></section> <section><p>A cursor declared on a <i>ResultSet</i> that includes an aggregate in the outer query block is not updatable.</p></section> -<section><p>This section includes the following aggregates: <ul> +<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> supports +the following aggregates:<ul> <li><xref href="rrefsqlj32693.dita#rrefsqlj32693"></xref></li> <li><xref href="rrefsqlj38716.dita#rrefsqlj38716"></xref></li> <li><xref href="rrefsqlj27781.dita#rrefsqlj27781"></xref></li>