diff options
Diffstat (limited to 'doc/man/update.l')
-rw-r--r-- | doc/man/update.l | 43 |
1 files changed, 0 insertions, 43 deletions
diff --git a/doc/man/update.l b/doc/man/update.l deleted file mode 100644 index 6e034088ee9..00000000000 --- a/doc/man/update.l +++ /dev/null @@ -1,43 +0,0 @@ -.\" This is -*-nroff-*- -.\" XXX standard disclaimer belongs here.... -.\" $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 -.SH SYNOPSIS -.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 -for all instances which satisfy the qualification, -.IR qual . -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 -or qualification. -.SH EXAMPLES -.nf --- ---Give all employees who work for Smith a 10% raise --- -update emp - set sal = 1.1 * sal - where mgr = 'Smith' -.fi -.SH "SEE ALSO" -create table(l), -select(l). |