On 9/18/23 00:41, Erik Wienhold wrote:
> On 18/09/2023 00:13 CEST David E. Wheeler <david(at)justatheory(dot)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