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
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 |