diff options
| author | Bruce Momjian | 1998-03-18 15:49:08 +0000 |
|---|---|---|
| committer | Bruce Momjian | 1998-03-18 15:49:08 +0000 |
| commit | c530fbfb2fa4177103a44147315a3217c6527dd6 (patch) | |
| tree | 708adca73b428d3fa16b9b57f266e86898a08da4 /src/man | |
| parent | 94abcc16653a2ac82f2bf52c8669aa675dbebffe (diff) | |
Add checks for UNION target fields, and add optional TABLE to LOCK
and SELECT manual pages and psql help.
Diffstat (limited to 'src/man')
| -rw-r--r-- | src/man/lock.l | 6 | ||||
| -rw-r--r-- | src/man/select.l | 4 |
2 files changed, 5 insertions, 5 deletions
diff --git a/src/man/lock.l b/src/man/lock.l index 0572923e85..b0b053377b 100644 --- a/src/man/lock.l +++ b/src/man/lock.l @@ -1,12 +1,12 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/lock.l,v 1.3 1998/01/28 20:44:42 momjian Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/lock.l,v 1.4 1998/03/18 15:48:57 momjian Exp $ .TH FETCH SQL 01/23/93 PostgreSQL PostgreSQL .SH NAME lock - exclusive lock a table .SH SYNOPSIS .nf -\fBlock\fR classname +\fBlock\fR [\fBtable\fR] classname .fi .SH DESCRIPTION .BR lock @@ -31,7 +31,7 @@ aquisitions and requests to not form a deadlock. -- Proper locking to prevent deadlock -- begin work; -lock mytable; +lock table mytable; select * from mytable; update mytable set (x = 100); end work; diff --git a/src/man/select.l b/src/man/select.l index d2b54d3638..739e23c13d 100644 --- a/src/man/select.l +++ b/src/man/select.l @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/select.l,v 1.4 1998/01/11 22:17:58 momjian Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/select.l,v 1.5 1998/03/18 15:49:08 momjian Exp $ .TH SELECT SQL 11/05/95 PostgreSQL PostgreSQL .SH NAME select - retrieve instances from a class @@ -9,7 +9,7 @@ select - retrieve instances from a class \fBselect\fR [distinct] expression1 [\fBas\fR attr_name-1] {, expression-1 [\fBas\fR attr_name-i]} - [\fBinto\fR \fBtable\fR classname] + [\fBinto\fR [\fBtable\fR] classname] [\fBfrom\fR from-list] [\fBwhere\fR where-clause] [\fBgroup by\fR attr_name1 {, attr_name-i....}] |