diff options
author | Robert Haas <rhaas@postgresql.org> | 2014-04-16 12:21:43 -0400 |
---|---|---|
committer | Robert Haas <rhaas@postgresql.org> | 2014-04-16 12:21:43 -0400 |
commit | dfc0219f649d5450a5e4d491dab1eeb23ac5530a (patch) | |
tree | 545656271ca895402dc25ea3bff1b97934cd0210 /doc/src | |
parent | 1a81daab8be9a0b3769a2660db44a56a6035e34a (diff) | |
download | postgresql-dfc0219f649d5450a5e4d491dab1eeb23ac5530a.tar.gz postgresql-dfc0219f649d5450a5e4d491dab1eeb23ac5530a.zip |
Add to_regprocedure() and to_regoperator().
These are natural complements to the functions added by commit
0886fc6a5c75b294544263ea979b9cf6195407d9, but they weren't included
in the original patch for some reason. Add them.
Patch by me, per a complaint by Tom Lane. Review by Tatsuo
Ishii.
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/func.sgml | 28 |
1 files changed, 24 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 1759c8876c4..148f0bc2378 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15294,10 +15294,18 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); </indexterm> <indexterm> + <primary>to_regprocedure</primary> + </indexterm> + + <indexterm> <primary>to_regoper</primary> </indexterm> <indexterm> + <primary>to_regoperator</primary> + </indexterm> + + <indexterm> <primary>to_regtype</primary> </indexterm> @@ -15482,11 +15490,21 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); <entry>get the oid of the named function</entry> </row> <row> + <entry><literal><function>to_regprocedure(<parameter>func_name</parameter>)</function></literal></entry> + <entry><type>regprocedure</type></entry> + <entry>get the oid of the named function</entry> + </row> + <row> <entry><literal><function>to_regoper(<parameter>operator_name</parameter>)</function></literal></entry> <entry><type>regoper</type></entry> <entry>get the oid of the named operator</entry> </row> <row> + <entry><literal><function>to_regoperator(<parameter>operator_name</parameter>)</function></literal></entry> + <entry><type>regoperator</type></entry> + <entry>get the oid of the named operator</entry> + </row> + <row> <entry><literal><function>to_regtype(<parameter>type_name</parameter>)</function></literal></entry> <entry><type>regtype</type></entry> <entry>get the oid of the named type</entry> @@ -15658,10 +15676,12 @@ SELECT collation for ('foo' COLLATE "de_DE"); <para> The <function>to_regclass</function>, <function>to_regproc</function>, - <function>to_regoper</function> and <function>to_regtype</function> - translate relation, function, operator, and type names to objects of - type <type>regclass</>, <type>regproc</>, <type>regoper</> and - <type>regtype</>, respectively. These functions differ from a cast from + <function>to_regprocedure</function>, <function>to_regoper</function>, + <function>to_regoperator</function>, and <function>to_regtype</function> + functions translate relation, function, operator, and type names to objects + of type <type>regclass</>, <type>regproc</>, <type>regprocedure</type>, + <type>regoper</>, <type>regoperator</type>, and <type>regtype</>, + respectively. These functions differ from a cast from text in that they don't accept a numeric OID, and that they return null rather than throwing an error if the name is not found (or, for <function>to_regproc</function> and <function>to_regoper</function>, if |