Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Updates to the generated column documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
2d23316bb5f2bb47d5ad20e9b1eb96e2 |
| User & Date: | drh 2020-01-22 17:13:56 |
Context
|
2020-01-22
| ||
| 17:49 | Fix documentation typos. check-in: 1894a02a1f user: drh tags: trunk | |
| 17:13 | Updates to the generated column documentation. check-in: 2d23316bb5 user: drh tags: trunk | |
|
2020-01-21
| ||
| 20:14 | Update the speed-and-size spreadsheet. check-in: 6639a1d518 user: drh tags: trunk | |
Changes
Changes to pages/gencol.in.
103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 |
specified by the expression that follows the "AS" keyword. <li><p> ^Generated columns may not be used as part of the [PRIMARY KEY]. (Future versions of SQLite might relax this constraint for STORED columns.) <li><p> ^The expression of a generated column has the same restrictions as the expression of a [CHECK constraint]: The expression may only reference constant literals and columns within the same row, and may only use scalar [deterministic functions]. ^The expression may not use subqueries, aggregate functions, window functions, or table-valued functions. <li><p> ^The expression of a generated column may refer to other generated columns in the same row, but no generated column can depend upon itself, either |
| < |
103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 |
specified by the expression that follows the "AS" keyword.
<li><p>
^Generated columns may not be used as part of the [PRIMARY KEY].
(Future versions of SQLite might relax this constraint for STORED columns.)
<li><p>
^The expression of a generated column may only reference
constant literals and columns within the same row, and may only use
scalar [deterministic functions]. ^The expression may not use subqueries,
aggregate functions, window functions, or table-valued functions.
<li><p>
^The expression of a generated column may refer to other generated columns
in the same row, but no generated column can depend upon itself, either
|