diff options
Diffstat (limited to 'doc/man/update.l')
| -rw-r--r-- | doc/man/update.l | 12 |
1 files changed, 7 insertions, 5 deletions
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 |