Translates a textual operator name (with parameter types) to its OID. A similar result is obtained by casting the string to type regoperator (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found.
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
regoperator (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found.to_regoperator ( text ) → regoperator → regoperatorTranslates a textual operator name (with parameter types) to its OID. A similar result is obtained by casting the string to type
regoperator (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found.{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:11588c99d5a2ba90215d5faa465eca088f4cc13a46d5d42304b9e755cea09207
Text language: en · wiki-repair-20261023:11588c99d5a2ba90215d5faa465eca088f4cc13a46d5d42304b9e755cea09207