Documentation Source Text

Check-in [957ac800cf]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a missing end-requirement mark in the expression documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 957ac800cff5e6798205465807117bbbadbe4131
User & Date: drh 2011-06-04 23:20:02.343
Context
2011-06-08
15:11
Fix a typo in the how-to-corrupt document. (check-in: a1408d26c6 user: drh tags: trunk)
2011-06-04
23:20
Fix a missing end-requirement mark in the expression documentation. (check-in: 957ac800cf user: drh tags: trunk)
2011-05-31
11:56
Update the documentation to state that the LIMIT of a scalar subquery is always 1. (check-in: 8d37b80354 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/lang.in.
1844
1845
1846
1847
1848
1849
1850
1851
1852
1853
1854
1855
1856
1857
1858
<p>^A [SELECT] statement enclosed in parentheses may appear as a scalar
quantity. ^A [SELECT] used as a scalar quantity must return a result set
with a single column. ^The result of the expression is the value of the
only column in the first row returned by the SELECT statement. ^If the SELECT 
yields more than one result row, all rows after the first are ignored. ^If
the SELECT yields no rows, then the value of the expression is NULL.
^(The LIMIT of a scalar subquery is always 1.
Any other LIMIT value given in the SQL text is ignored.)

<p>^All types of [SELECT] statement, including aggregate and compound SELECT
queries (queries with keywords like UNION or EXCEPT) are allowed as scalar
subqueries.

<h3>Table Column Names</h3>








|







1844
1845
1846
1847
1848
1849
1850
1851
1852
1853
1854
1855
1856
1857
1858
<p>^A [SELECT] statement enclosed in parentheses may appear as a scalar
quantity. ^A [SELECT] used as a scalar quantity must return a result set
with a single column. ^The result of the expression is the value of the
only column in the first row returned by the SELECT statement. ^If the SELECT 
yields more than one result row, all rows after the first are ignored. ^If
the SELECT yields no rows, then the value of the expression is NULL.
^(The LIMIT of a scalar subquery is always 1.
Any other LIMIT value given in the SQL text is ignored.)^

<p>^All types of [SELECT] statement, including aggregate and compound SELECT
queries (queries with keywords like UNION or EXCEPT) are allowed as scalar
subqueries.

<h3>Table Column Names</h3>