Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Correct overly restrictive language on row value usage in expressions doc, as noted in forum post 37b7b3ffe5. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
db474f5440ed68063c679644ec71dd1a |
| User & Date: | larrybr 2022-12-18 03:44:29 |
Context
|
2022-12-21
| ||
| 04:58 | Detect and fail incremental doc build for broken links where an uptodate source links to a gone-missing tag definition in an outdated source. Also cleanup a few minor deviations from project coding standard and move a few Tcl functions to the sources that use them (because that makes incremental builds work simply.) (check-in: 9366017013 user: larrybr tags: trunk) | |
| 04:41 | Sync w/trunk and move some Tcl procs to where they are used to make build more incremental-friendly. (check-in: a7b22a1fb3 user: larrybr tags: docgen_speedup) | |
|
2022-12-18
| ||
| 03:44 | Correct overly restrictive language on row value usage in expressions doc, as noted in forum post 37b7b3ffe5. (check-in: db474f5440 user: larrybr tags: trunk) | |
|
2022-12-16
| ||
| 17:48 | Doc build speed and convenience improvements. Run bare "make" for details. (check-in: 4a0d21d374 user: larrybr tags: trunk) | |
Changes
Changes to pages/lang_expr.in.
| ︙ | ︙ | |||
539 540 541 542 543 544 545 | from the enclosed [SELECT] statement. ^The value of a subquery expression is NULL if the enclosed [SELECT] statement returns no rows. <p>A subquery that returns a single column is a scalar subquery and can be used most anywhere. ^A subquery that returns two or more columns is a [row value] | | > | 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 |
from the enclosed [SELECT] statement.
^The value of a subquery expression is NULL if the enclosed
[SELECT] statement returns no rows.
<p>A subquery that returns a single column is a scalar subquery and can
be used most anywhere.
^A subquery that returns two or more columns is a [row value]
subquery and can only be used as an operand of a comparison operator or as
the value in an UPDATE SET clause whose column name list has the same size.
<tcl>hd_fragment cosub {correlated subqueries}</tcl>
<h1>Correlated Subqueries</h1>
<p>^A [SELECT] statement used as either a scalar subquery or as the
right-hand operand of an IN, NOT IN or EXISTS expression may contain
references to columns in the outer query. Such a subquery is known as
|
| ︙ | ︙ |