drop_operator man page on IRIX

Man page or keyword search:  
man Server   31559 pages
apropos Keyword Search (all sections)
Output format
IRIX logo
[printable version]



     DROP OPERATOR(SQL - Language Statements (2002-11-DROP OPERATOR(l)

     NAME
	  DROP OPERATOR - remove a user-defined operator

     SYNOPSIS
	  DROP OPERATOR id ( lefttype | NONE , righttype | NONE ) [ CASCADE | RESTRICT ]

	INPUTS
	  id   The identifier (optionally schema-qualified) of an
	       existing operator.

	  lefttype
	       The type of the operator's left argument; write NONE if
	       the operator has no left argument.

	  righttype
	       The type of the operator's right argument; write NONE
	       if the operator has no right argument.

	  CASCADE
	       Automatically drop objects that depend on the operator.

	  RESTRICT
	       Refuse to drop the operator if there are any dependent
	       objects.	 This is the default.

	OUTPUTS
	  DROP OPERATOR
	       The message returned if the command is successful.

     and 'righttype' does not exist
	  ERROR: RemoveOperator: binary operator 'oper' taking 'lefttype'
	       This message occurs if the specified binary operator
	       does not exist.

	  ERROR: RemoveOperator: left unary operator 'oper' taking
	       This message occurs if the left unary operator
	       specified does not exist.

	  ERROR: RemoveOperator: right unary operator 'oper' taking
	       This message occurs if the right unary operator
	       specified does not exist.

     DESCRIPTION
	  DROP OPERATOR drops an existing operator from the database.
	  To execute this command you must be the owner of the
	  operator.

	  The left or right type of a left or right unary operator,
	  respectively, must be specified as NONE.

     Page 1					     (printed 3/24/03)

     DROP OPERATOR(SQL - Language Statements (2002-11-DROP OPERATOR(l)

	NOTES
	  The DROP OPERATOR statement is a PostgreSQL language
	  extension.

	  Refer to CREATE OPERATOR [create_operator(l)] for
	  information on how to create operators.

     USAGE
	  Remove power operator a^n for int4:

	  DROP OPERATOR ^ (int4, int4);

	  Remove left unary negation operator (! b) for boolean:

	  DROP OPERATOR ! (none, bool);

	  Remove right unary factorial operator (i !) for int4:

	  DROP OPERATOR ! (int4, none);

     COMPATIBILITY
	SQL92
	  There is no DROP OPERATOR in SQL92.

     Page 2					     (printed 3/24/03)

[top]

List of man pages available for IRIX

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net