to_regoperator()

A function converting an operator name to its OID

to_regoperator() is a system function translating an operator name (with parameter types) to its OID.

to_regoperator() was added in PostgreSQL 9.4.

Usage

to_regoperator ( text ) → regoperator

NULL is returned if the specified combination of operator and parameter types is not found or does not exist.

Change history

Examples

Basic usage example for to_regoperator():

postgres=# SELECT to_regoperator('*(bigint,bigint)')::oid;
 to_regoperator 
----------------
            686
(1 row)

NULL is returned if the specified operator is not found or does not exist:

postgres=# SELECT to_regoperator('*(text,text)')::oid IS NULL;
 ?column? 
----------
 t
(1 row)

Categories

System function

See also

to_regoper()