db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From t...@apache.org
Subject svn commit: r520822 - /db/derby/docs/trunk/src/ref/rrefsqlj11277.dita
Date Wed, 21 Mar 2007 09:46:44 GMT
Author: tmnk
Date: Wed Mar 21 02:46:44 2007
New Revision: 520822

URL: http://svn.apache.org/viewvc?view=rev&rev=520822
-DERBY-2261 Questionable use of word statement in VALUES expression of Derby Reference Manual
should be changed to clause - Patch by Kim Haase (camilla.haase@sun.com)


Modified: db/derby/docs/trunk/src/ref/rrefsqlj11277.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj11277.dita?view=diff&rev=520822&r1=520821&r2=520822
--- db/derby/docs/trunk/src/ref/rrefsqlj11277.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj11277.dita Wed Mar 21 02:46:44 2007
@@ -25,15 +25,19 @@
 <section> <p>The VALUES expression allows construction of a row or a table
-from other values. You use a VALUES statement when you do not have a FROM
-clause. This construct can be used in all the places where a query can, and
-thus can be used as a statement that returns a <i>ResultSet</i>, within expressions
-and statements wherever subqueries are permitted, and as the source of values
-for an INSERT statement.</p> </section>
+from other values. A VALUES expression can be used in all the places where a
+query can, and thus can be used in any of the following ways:
+<li>As a statement that returns a <i>ResultSet</i></li>
+<li>Within expressions and statements wherever subqueries are permitted</li>
+<li>As the source of values for an INSERT statement (in an INSERT statement, 
+you normally use a VALUES expression when you do not use a 
+<i><xref href="rrefselectexpression.dita#rrefselectexpression"></xref></i>)</li>
+</ul></p> </section>
 <refsyn><title>Syntax</title> <codeblock><b>{
     VALUES ( <i>Value</i> {, <i>Value</i> }* )
         [ , ( <i>Value</i> {, <i>Value</i> }* ) ]* |
-    VALUES <i>Value</i> [ , <i>Value</i> ]* |
+    VALUES <i>Value</i> [ , <i>Value</i> ]*
 <p>where <i>Value</i> is defined as</p>
 <codeblock><b><i>Expression</i> | DEFAULT</b></codeblock>

View raw message