Translates a textual operator name to its OID. A similar result is obtained by casting the string to type regoper (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found or is ambiguous.
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
regoper (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found or is ambiguous.to_regoper ( text ) → regoper → regoperTranslates a textual operator name to its OID. A similar result is obtained by casting the string to type
regoper (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found or is ambiguous.{"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:26ef79a6e44a68f307de302933906c4d41ce20f8ec17eadcafbc8a9cdb8278a6
Text language: en · wiki-repair-20261023:26ef79a6e44a68f307de302933906c4d41ce20f8ec17eadcafbc8a9cdb8278a6