db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r638353 - /db/derby/docs/trunk/src/ref/rrefsqlj33923.dita
Date Tue, 18 Mar 2008 12:50:47 GMT
Author: rhillegas
Date: Tue Mar 18 05:50:43 2008
New Revision: 638353

URL: http://svn.apache.org/viewvc?rev=638353&view=rev
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
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.</p></section>
+over a set of values as well as count rows.</p></section>
 <section><p><indexterm>Aggregates<indexterm>and data types</indexterm></indexterm>The
 built-in aggregates can operate on the data types shown in <xref href="rrefsqlj33923.dita#rrefsqlj33923/sqlj92398"></xref>.
   <table frame="all" id="sqlj92398"><title>Permitted Data Types for Built-in
@@ -38,7 +37,7 @@
-<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>
@@ -51,22 +50,22 @@
 <entry colname="1">MIN</entry>
-<entry colname="2"></entry>
+<entry colname="2">&nbsp;</entry>
 <entry colname="3">X</entry>
 <entry colname="1">MAX</entry>
-<entry colname="2"></entry>
+<entry colname="2">&nbsp;</entry>
 <entry colname="3">X</entry>
 <entry colname="1">AVG</entry>
-<entry colname="2"></entry>
+<entry colname="2">&nbsp;</entry>
 <entry colname="3">X</entry>
 <entry colname="1">SUM</entry>
-<entry colname="2"></entry>
+<entry colname="2">&nbsp;</entry>
 <entry colname="3">X</entry>
@@ -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>
+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>

View raw message