Hello Hackers, On Feb 25, 2024, at 13:00, David E. Wheeler <da...@justatheory.com> wrote:
>> postgres=# SELECT to_regtypemod('timestamp(-4)');
>> ERROR: syntax error at or near "-"
>> LINE 1: SELECT to_regtypemod('timestamp(-4)');
>> ^
>> CONTEXT: invalid type name "timestamp(-4)"
>>
>> postgres=# SELECT to_regtypemod('text(-4)');
>> ERROR: type modifier is not allowed for type "text"
>
> Yeah, there was quite a bit of discussion of this issue back in September[1].
>
>> This behaviour is mentioned in the documentation, so I'd say it is ok.
>
> This is my attempt to make it clearer that it can return an error, but I
> don’t love the wording TBH.
I’ve rebased the patch and, in an attempt to clarify this behavior, added a
couple of examples to the docs for to_regtype. Updated patch attached.
Best,
David
v10-0001-Add-to_regtypemod-SQL-function.patch
Description: Binary data
