delete.l
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- ." This is -*-nroff-*-
- ." XXX standard disclaimer belongs here....
- ." $Header: /usr/local/cvsroot/pgsql/src/man/Attic/delete.l,v 1.4 1998/06/24 13:21:25 momjian Exp $
- .TH DELETE SQL 11/05/95 PostgreSQL PostgreSQL
- .SH NAME
- delete - delete instances from a class
- .SH SYNOPSIS
- .nf
- fBdeletefR fBfromfR class_name [ fBwherefR qual ]
- .fi
- .SH DESCRIPTION
- .BR Delete
- removes instances which satisfy the qualification,
- .IR qual
- from the specified class.
- 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.
- .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).