Documentation Source Text: Check-in [db4e5cec36]

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

Overview

Comment:	Fix a LHS/RHS mixup in the rowvalue documentation.
Downloads:	Tarball \| ZIP archive \| SQL archive
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA1:	db4e5cec36e1353c8d64ea2a4611e0842c2e6d94
User & Date:	drh 2016-09-23 11:32:36

Context

2016-09-23
14:33		Add an example of using row values in an UPDATE to the row value document. (check-in: 0bc1f4cfc7 user: drh tags: trunk)
11:32		Fix a LHS/RHS mixup in the rowvalue documentation. (check-in: db4e5cec36 user: drh tags: trunk)
2016-09-22
18:03		Provide for alternative document titles using <alt-title>...</alt-title>. Have the document page come up with the first sublist (containing lists of other documents) open automatically. (check-in: 22726478ad user: drh tags: trunk)

Changes

Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/rowvalue.in.

   (7,8,9) IN (SELECT * FROM t2),  -- 0
   (1,3,5) IN (SELECT * FROM t2);  -- NULL
</codeblock>

<h2>Row Values In UPDATE Statements</h2>

<p>Row values can also be used in the SET clause of an [UPDATE] statement.
The RHS must be a list of column names.  The LHS can be any row value.
For example:

<codeblock>
UPDATE tab3 
   SET (a,b,c) = (SELECT x,y,z
                    FROM tab4
                   WHERE tab4.w=tab3.d);

   (7,8,9) IN (SELECT * FROM t2),  -- 0
   (1,3,5) IN (SELECT * FROM t2);  -- NULL
</codeblock>

<h2>Row Values In UPDATE Statements</h2>

<p>Row values can also be used in the SET clause of an [UPDATE] statement.
The LHS must be a list of column names.  The RHS can be any row value.
For example:

<codeblock>
UPDATE tab3 
   SET (a,b,c) = (SELECT x,y,z
                    FROM tab4
                   WHERE tab4.w=tab3.d);