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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
957ac800cff5e6798205465807117bbb |
| User & Date: | drh 2011-06-04 23:20:02 |
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
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>
|