Documentation Source Text

Check-in [b5882b3f8f]
Login

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

Overview
Comment:Change to requirement marks in lang.in.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b5882b3f8fbebb225c53d0625b66f293eb8bee50
User & Date: dan 2010-09-11 17:46:27
Context
2010-09-13
12:06
Added documentation on the SQLITE_4_BYTE_ALIGNED_MALLOC compile-time option. check-in: dc93bef322 user: drh tags: trunk
2010-09-11
17:46
Change to requirement marks in lang.in. check-in: b5882b3f8f user: dan tags: trunk
2010-09-10
19:11
Minor changes to lang.in. check-in: 8efac9af2b user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

  2821   2821       the GROUP BY and HAVING clauses to the filtered input dataset.
  2822   2822   </ul>
  2823   2823   
  2824   2824   <p><b>4. Removal of duplicate rows (DISTINCT processing).</b>
  2825   2825   <tcl>hd_fragment distinct</tcl>
  2826   2826   <tcl>hd_keywords {DISTINCT}</tcl>
  2827   2827   
  2828         -<p>^(One of the ALL or DISTINCT keywords may follow the SELECT keyword in a 
  2829         -simple SELECT statement. If neither of these are present, then the behaviour
  2830         -is as if ALL were specified.)^ ^If the simple SELECT is a SELECT ALL, then the
  2831         -entire set of result rows are returned by the SELECT. ^If the simple SELECT
  2832         -is a SELECT DISTINCT, then duplicate rows are removed from the set of result
  2833         -rows before it is returned. ^For the purposes of detecting duplicate rows,
  2834         -two NULL values are considered to be equal. ^The normal rules for selecting
  2835         -a collation sequence to compare text values with apply.
         2828  +<p>^One of the ALL or DISTINCT keywords may follow the SELECT keyword in a 
         2829  +simple SELECT statement. ^If the simple SELECT is a SELECT ALL, then the
         2830  +entire set of result rows are returned by the SELECT. ^If neither ALL or
         2831  +DISTINCT are present, then the behaviour is as if ALL were specified. 
         2832  +^If the simple SELECT is a SELECT DISTINCT, then duplicate rows are removed
         2833  +from the set of result rows before it is returned. ^For the purposes of
         2834  +detecting duplicate rows, two NULL values are considered to be equal. ^The
         2835  +normal rules for selecting a collation sequence to compare text values with
         2836  +apply.
  2836   2837   
  2837   2838   <h3>Compound Select Statements</h3>
  2838   2839   
  2839   2840   <p>^A compound SELECT is formed from two or more simple SELECTs connected
  2840   2841   by one of the operators UNION, UNION ALL, INTERSECT, or EXCEPT.  ^In
  2841   2842   a compound SELECT, all the constituent SELECTs must specify the
  2842   2843   same number of result columns.  ^There may be only a single ORDER BY