Re: to_regtype() Raises Error

On 9/18/23 00:41, Erik Wienhold wrote:
> On 18/09/2023 00:13 CEST David E. Wheeler <david@justatheory.com> wrote:
> 
>> 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”
> 
> Probably a typo and you meant 'interval second' which works.
No, that is precisely the point.  The result should be null instead of 
an error.
-- 
Vik Fearing