diff options
| author | Bruce Momjian <bruce@momjian.us> | 1996-10-07 02:34:54 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1996-10-07 02:34:54 +0000 |
| commit | 9d9eadea82b49b8bc2c089b2dfa1e19a557bf323 (patch) | |
| tree | 7cc9c8733c25af56518b25f83e509964729d3cf0 | |
| parent | f6792efcc7c39b6bc86406ce0c51d20ef9eb1243 (diff) | |
| download | postgresql-9d9eadea82b49b8bc2c089b2dfa1e19a557bf323.tar.gz postgresql-9d9eadea82b49b8bc2c089b2dfa1e19a557bf323.zip | |
add FROM to update page, clean up spelling error in select.
| -rw-r--r-- | doc/man/select.l | 4 | ||||
| -rw-r--r-- | doc/man/update.l | 12 |
2 files changed, 9 insertions, 7 deletions
diff --git a/doc/man/select.l b/doc/man/select.l index 8013cede3ca..44ad9736c7f 100644 --- a/doc/man/select.l +++ b/doc/man/select.l @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/doc/man/Attic/select.l,v 1.1.1.1 1996/08/18 22:14:27 scrappy Exp $ +.\" $Header: /cvsroot/pgsql/doc/man/Attic/select.l,v 1.2 1996/10/07 02:34:53 momjian Exp $ .TH SELECT SQL 11/05/95 Postgres95 Postgres95 .SH NAME select \(em retrieve instances from a class @@ -10,7 +10,7 @@ select \(em retrieve instances from a class expression1 [\fBas\fR attr_name-1] {, expression-1 [\fBas\fR attr_name-i]} [\fBinto\fR \fBtable\fR classname] - [\fBfrom\fR from-last] + [\fBfrom\fR from-list] [\fBwhere\fR where-clause] [\fBgroup by\fR attr_name1 {, attr_name-i....} [\fBorder by\fR attr_name1 diff --git a/doc/man/update.l b/doc/man/update.l index 4b7bb25e386..6e034088ee9 100644 --- a/doc/man/update.l +++ b/doc/man/update.l @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/doc/man/Attic/update.l,v 1.1.1.1 1996/08/18 22:14:28 scrappy Exp $ +.\" $Header: /cvsroot/pgsql/doc/man/Attic/update.l,v 1.2 1996/10/07 02:34:54 momjian Exp $ .TH UPDATE SQL 11/05/95 Postgres95 Postgres95 .SH NAME update \(em replace values of attributes in a class @@ -8,21 +8,23 @@ update \(em replace values of attributes in a class .nf \fBupdate\fR classname \fBset\fR attname-1 = expression-1, {attname-i = expression-i} + [\fBfrom\fR from-list] [\fBwhere\fR qual] .fi .SH DESCRIPTION .BR Update -changes the values of the attributes specified in -.IR target_list +changes the values of the attributes specified for all instances which satisfy the qualification, .IR qual . -Only the attributes to be modified need appear in -.IR target_list . +Only the attributes to be modified need appear as atributes. .PP Array references use the same syntax found in .IR select(l). That is, either single array elements, a range of array elements or the entire array may be replaced with a single query. +.IR from-list +is a non-standard extension to allow columns from +other tables to appear in the target_list. .PP You must have write access to the class in order to modify it, as well as read access to any class whose values are mentioned in the target list |