You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by tm...@apache.org on 2007/03/21 10:46:44 UTC

svn commit: r520822 - /db/derby/docs/trunk/src/ref/rrefsqlj11277.dita

Author: tmnk
Date: Wed Mar 21 02:46:44 2007
New Revision: 520822

URL: http://svn.apache.org/viewvc?view=rev&rev=520822
Log:
-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

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 @@
 </metadata></prolog>
 <refbody>
 <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:
+<ul>
+<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> ]*
  }</b></codeblock> 
 <p>where <i>Value</i> is defined as</p>
 <codeblock><b><i>Expression</i> | DEFAULT</b></codeblock>