diff options
| author | Bruce Momjian | 1999-06-03 19:52:09 +0000 |
|---|---|---|
| committer | Bruce Momjian | 1999-06-03 19:52:09 +0000 |
| commit | a4a5f562025a932cb17c178eedad8b07e8cf4cfa (patch) | |
| tree | fec88a47a6830726c293f6a96d6a87304f248f61 /doc/src | |
| parent | e1ea7cc2e562b9e61528f37affada72a08a8adeb (diff) | |
Add mention of FOR UPDATE and LIMIT/OFFSET>
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 9b49285b497..110ec117c2d 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -26,6 +26,8 @@ SELECT [ALL|DISTINCT [ON <replaceable class="PARAMETER">column</replaceable>] ] [ HAVING <replaceable class="PARAMETER">condition</replaceable> [, ...] ] [ { UNION [ALL] | INTERSECT | EXCEPT } <replaceable class="PARAMETER">select</replaceable> ] [ ORDER BY <replaceable class="PARAMETER">column</replaceable> [ ASC | DESC ] [, ...] ] + [ FOR UPDATE [OF class_name...]] + [ LIMIT count [OFFSET|, count]] </synopsis> <refsect2 id="R2-SQL-SELECT-1"> @@ -243,6 +245,15 @@ including duplicates.</para> (See EXCEPT clause).</para> <para> + The FOR UPDATE clause allows the SELECT statement to perform + exclusive locking of selected rows. + (See EXCEPT clause).</para> + + <para> + The LIMIT...OFFSET clause allows control over which rows are + returned by the query.</para> + + <para> You must have SELECT privilege to a table to read its values (See <command>GRANT</command>/<command>REVOKE</command> statements). </para> @@ -709,6 +720,8 @@ SELECT [ ALL | DISTINCT ] <replaceable class="PARAMETER">expression</replaceable [ HAVING <replaceable class="PARAMETER">condition</replaceable> [, ...] ] [ { UNION [ALL] | INTERSECT | EXCEPT } <replaceable class="PARAMETER">select</replaceable>] [ ORDER BY <replaceable class="PARAMETER">column</replaceable> [ ASC | DESC ] [, ...] ] + [ FOR UPDATE [OF class_name...]] + [ LIMIT count [OFFSET|, count]] </synopsis> <refsect2 id="R2-SQL-SELECTINTO-1"> |