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*"/>
-
+Function Name
All Types
Numeric Built-in Data Types
@@ -51,22 +50,22 @@
MIN
-
+
X
MAX
-
+
X
AVG
-
+
X
SUM
-
+
X
@@ -104,7 +103,8 @@
WHERE t2.y = SUM(t1.c3))
A cursor declared on a ResultSet that includes an aggregate
in the outer query block is not updatable.
-This section includes the following aggregates: