PostgreSQL

Скачать в pdf «PostgreSQL»


Inputs


name The name of an existing procedural language.


Outputs


DROP This message is returned if the language is successfully dropped.


ERROR: Language «name » doesn’t exist This message occurs if a language called name is not found in the database.


Description


DROP PROCEDURAL LANGUAGE will remove the definition of the previously registered procedural language called name.


Notes


The DROP PROCEDURAL LANGUAGE statement is a Postgres language extension.


Refer to CREATE LANGUAGE for information on how to create procedural languages.


No checks are made if functions or trigger procedures registered in this language still exist. To re-enable them without having to drop and recreate all the functions, the pg_proc’s prolang attribute of the functions must be adjusted to the new object ID of the recreated pg_language entry for the PL.


Usage


This command removes the PL/Sample language: drop procedural language ‘plsample’;


Compatibility


SQL92


There is no DROP PROCEDURAL LANGUAGE in SQL92.

d.38 drop operator


Name


DROP OPERATOR — Removes an operator from the database DROP OPERATOR id (type | NONE [,…] )


Inputs


id The identifier of an existing operator. type The type of function parameters.


Outputs


DROP The message returned if the command is successful.


ERROR: RemoveOperator: binary operator ’oper’ taking ’type’ and ’type2’ does not exist


This message occurs if the specified binary operator does not exist.


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

Скачать в pdf «PostgreSQL»