to_regtype() Raises Error

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: to_regtype() Raises Error
Date: 2023-09-17 22:13:56
Message-ID: 09F9CAD6-5096-43CC-B6A7-685703E4714D@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The docs for `to_regtype()` say, “this function will return NULL rather than throwing an error if the name is not found.” And it’s true most of the time:

david=# select to_regtype('foo'), to_regtype('clam');
to_regtype | to_regtype
------------+------------
[null] | [null]

But not others:

david=# select to_regtype('inteval second');
ERROR: syntax error at or near "second"
LINE 1: select to_regtype('inteval second');
^
CONTEXT: invalid type name "inteval second”

I presume this has something to do with not catching errors from the parser?

david=# select to_regtype('clam bake');
ERROR: syntax error at or near "bake"
LINE 1: select to_regtype('clam bake');
^
CONTEXT: invalid type name "clam bake"

Best,

David

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Erik Wienhold 2023-09-17 22:41:01 Re: to_regtype() Raises Error
Previous Message David E. Wheeler 2023-09-17 22:09:36 Re: JSON Path and GIN Questions