On Sunday, September 17, 2023, Chapman Flack <
chap@anastigmatix.net> wrote:
In this one, both identifiers are part of the type name, and the
separator a little more flamboyant.
select to_regtype('character /* hi!
am I part of the type name? /* what, me too? */ ok! */ -- huh!
varying');
to_regtype
-------------------
character varying
So, maybe we should be saying:
Parses a string of text, extracts a potential type name from it, and translates that name into an OID. Failure to extract a valid potential type name results in an error while a failure to determine that the extracted name is known to the system results in a null output.
I take specific exception to describing your example as a “textual type name”.
David J.