From 9848d3655d44aa2e58d28fe9f93a94b2934eedc8 Mon Sep 17 00:00:00 2001 From: Marc G. Fournier Date: Sun, 18 Aug 1996 22:14:33 +0000 Subject: Support Docs & Contrib --- doc/man/delete.l | 41 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 doc/man/delete.l (limited to 'doc/man/delete.l') diff --git a/doc/man/delete.l b/doc/man/delete.l new file mode 100644 index 00000000000..5836a4756e1 --- /dev/null +++ b/doc/man/delete.l @@ -0,0 +1,41 @@ +.\" This is -*-nroff-*- +.\" XXX standard disclaimer belongs here.... +.\" $Header: /cvsroot/pgsql/doc/man/Attic/delete.l,v 1.1.1.1 1996/08/18 22:14:23 scrappy Exp $ +.TH DELETE SQL 11/05/95 Postgres95 Postgres95 +.SH NAME +delete \(em delete instances from a class +.SH SYNOPSIS +.nf +\fBdelete\fR instance_variable [ \fBfrom\fR from_list ] [ \fBwhere\fR qual ] +.fi +.SH DESCRIPTION +.BR Delete +removes instances which satisfy the qualification, +.IR qual , +from the class specified by +.IR instance_variable . +.IR Instance_variable +is either a class name or a variable assigned by +.IR from_list . +If the qualification is absent, the effect is to delete all instances +in the class. The result is a valid, but empty class. +.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 read in the qualification +(see +.IR "change acl" (l). +.SH EXAMPLE +.nf +-- +--Remove all employees who make over $30,000 +-- +delete from emp where emp.sal > 30000 +.fi +.nf +-- +--Clear the hobbies class +-- +delete from hobbies +.fi +.SH "SEE ALSO" +drop(l). -- cgit v1.2.3