Re: Function parameter type precision modifiers ignored.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Function parameter type precision modifiers ignored.
Дата
Msg-id 5361.1423262363@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Function parameter type precision modifiers ignored.  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-bugs
David G Johnston <david.g.johnston@gmail.com> writes:
> Tom Lane-2 wrote
>> Attributes applied to function parameter types --- or result types for
>> that matter --- are entirely ignored by Postgres; only the base type
>> matters.  This is documented.

> Maybe it would be more obvious in the section detailing "argtype"...but its
> not like its buried deep in the documentation.  The bigger problem is
> understanding exactly what that notes means in reality.  Often that means
> getting bit by the behavior first and then reading about what just bit you.
> Happens to all of us.

> I'm for the idea of issuing a syntax error upon seeing "type()" in general
> but not strongly since perfectly valid code (often back-stopped by table
> constraints) currently works and would otherwise have no reason to change
> other than to conform to this decision.

Another possibility is to issue a WARNING or NOTICE rather than hard
error.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Function parameter type precision modifiers ignored.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #12739: to_timestamp function conver string to time incorrectly