From a4a5f562025a932cb17c178eedad8b07e8cf4cfa Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Thu, 3 Jun 1999 19:52:09 +0000
Subject: Add mention of FOR UPDATE and LIMIT/OFFSET>
---
doc/src/sgml/ref/select.sgml | 13 +++++++++++++
1 file changed, 13 insertions(+)
(limited to 'doc/src')
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 column] ]
[ HAVING condition [, ...] ]
[ { UNION [ALL] | INTERSECT | EXCEPT } select ]
[ ORDER BY column [ ASC | DESC ] [, ...] ]
+ [ FOR UPDATE [OF class_name...]]
+ [ LIMIT count [OFFSET|, count]]
@@ -242,6 +244,15 @@ including duplicates.
The EXCEPT give you the rows in the upper query not in the lower query.
(See EXCEPT clause).
+
+ The FOR UPDATE clause allows the SELECT statement to perform
+ exclusive locking of selected rows.
+ (See EXCEPT clause).
+
+
+ The LIMIT...OFFSET clause allows control over which rows are
+ returned by the query.
+
You must have SELECT privilege to a table to read its values
(See GRANT/REVOKE statements).
@@ -709,6 +720,8 @@ SELECT [ ALL | DISTINCT ] expressioncondition [, ...] ]
[ { UNION [ALL] | INTERSECT | EXCEPT } select]
[ ORDER BY column [ ASC | DESC ] [, ...] ]
+ [ FOR UPDATE [OF class_name...]]
+ [ LIMIT count [OFFSET|, count]]
--
cgit v1.2.3