db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1325753 - in /db/derby/docs/trunk/src/ref: rrefsqlj23075.dita rreftablesubquery.dita
Date Fri, 13 Apr 2012 13:13:06 GMT
Author: chaase3
Date: Fri Apr 13 13:13:06 2012
New Revision: 1325753

URL: http://svn.apache.org/viewvc?rev=1325753&view=rev
Log:
DERBY-5506  Document that EXISTS subquery can now select more then one column

Modified 2 Reference Manual topics.

Patch: DERBY-5506.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefsqlj23075.dita
    db/derby/docs/trunk/src/ref/rreftablesubquery.dita

Modified: db/derby/docs/trunk/src/ref/rrefsqlj23075.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj23075.dita?rev=1325753&r1=1325752&r2=1325753&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj23075.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj23075.dita Fri Apr 13 13:13:06 2012
@@ -152,9 +152,8 @@ HotelBookings WHERE rooms_available = 0)
 <row>
 <entry colname="1">EXISTS</entry>
 <entry colname="2">Operates on a table subquery. Returns TRUE if the table
-subquery returns any rows, and FALSE if it returns no rows. Table subquery
-can return multiple columns (only if you use * to denote multiple columns)
-and rows.   <codeblock><b>WHERE EXISTS
+subquery returns any rows, and FALSE if it returns no rows. A table subquery
+can return multiple columns and rows.   <codeblock><b>WHERE EXISTS
   (SELECT *
   FROM Flights
   WHERE dest_airport = 'SFO'

Modified: db/derby/docs/trunk/src/ref/rreftablesubquery.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreftablesubquery.dita?rev=1325753&r1=1325752&r2=1325753&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreftablesubquery.dita (original)
+++ db/derby/docs/trunk/src/ref/rreftablesubquery.dita Fri Apr 13 13:13:06 2012
@@ -33,9 +33,10 @@ multiple rows.</p> 
 a <xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref></li>
 <li>with EXISTS, IN, or quantified comparisons.</li>
 </ul></p> 
-<p>When used as a <i><xref href="rreftableexpression.dita#rreftableexpression">TableExpression</xref></i>
in a <xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref>, it can
return
-multiple columns. When used with EXISTS, it returns multiple columns only
-if you use * to return the multiple columns.</p>
+<p>When used as a
+<i><xref href="rreftableexpression.dita#rreftableexpression">TableExpression</xref></i>
+in a <xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref>, or with
+EXISTS, it can return multiple columns. </p>
 <p>When used with IN or quantified
 comparisons, it must return a single column.</p></section>
 <refsyn><title>Syntax</title>



Mime
View raw message