aboutsummaryrefslogtreecommitdiff
path: root/doc/man/update.l
diff options
context:
space:
mode:
authorMarc G. Fournier <scrappy@hub.org>1996-11-14 10:15:16 +0000
committerMarc G. Fournier <scrappy@hub.org>1996-11-14 10:15:16 +0000
commit389fe48cbb513888205bbe3a5008ed109976dacb (patch)
treee1bc978627338c127aa0d9c0fdbd8bed7fa6821c /doc/man/update.l
parent65a10b1be6400025e7fd54befbc4a8489fd50e10 (diff)
downloadpostgresql-389fe48cbb513888205bbe3a5008ed109976dacb.tar.gz
postgresql-389fe48cbb513888205bbe3a5008ed109976dacb.zip
Removed man pages...moved to src/man
Requested by Bryan
Diffstat (limited to 'doc/man/update.l')
-rw-r--r--doc/man/update.l43
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).