diff options
Diffstat (limited to 'doc/man/drop_operator.l')
-rw-r--r-- | doc/man/drop_operator.l | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/doc/man/drop_operator.l b/doc/man/drop_operator.l new file mode 100644 index 00000000000..a5e0bd3b175 --- /dev/null +++ b/doc/man/drop_operator.l @@ -0,0 +1,44 @@ +.\" This is -*-nroff-*- +.\" XXX standard disclaimer belongs here.... +.\" $Header: /cvsroot/pgsql/doc/man/Attic/drop_operator.l,v 1.1.1.1 1996/08/18 22:14:23 scrappy Exp $ +.TH "DROP OPERATOR" SQL 11/05/95 Postgres95 Postgres95 +.SH NAME +drop operator \(em remove an operator from the system +.SH SYNOPSIS +.nf +\fBdrop operator\fR opr_desc +.fi +.SH DESCRIPTION +This command drops an existing operator from the database. To execute +this command you must be the owner of the operator. +.PP +.IR Opr_desc +is the name of the operator to be removed followed by a parenthesized +list of the operand types for the operator. The left or right type +of a left or right unary operator, respectively, may be specified +as +.IR none . +.PP +It is the user's responsibility to remove any access methods, operator +classes, etc. that rely on the deleted operator. +.SH EXAMPLE +.nf +-- +--Remove power operator a^n for int4 +-- +drop operator ^ (int4, int4) +.fi +.nf +-- +--Remove left unary operator !a for booleans +-- +drop operator ! (none, bool) +.fi +.nf +-- +--Remove right unary factorial operator a! for int4 +-- +drop operator ! (int4, none) +.fi +.SH "SEE ALSO" +create operator(l). |