Re: Numeric Type Precision Not Respected in Function or Procedure Arguments

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Numeric Type Precision Not Respected in Function or Procedure Arguments
Дата
Msg-id CAKFQuwZ9vp+Ww2UAcrP2CsQ5Ye8CKD62R4FEts_aHLSLOv1sjw@mail.gmail.com
обсуждение исходный текст
Ответ на Numeric Type Precision Not Respected in Function or Procedure Arguments  (Aaron Ackerman <aackerman@goodmorning.com>)
Список pgsql-bugs
On Monday, September 22, 2025, Aaron Ackerman <aackerman@goodmorning.com> wrote:
When a NUMERIC type is used as a function or procedure argument, the
value does not actually follow the user-defined precision, such as
NUMERIC(10,4).

This is a known limitation - the “typmod” (type modifier) is not stored in the metadata for a function’s interface.

Pretty sure it’s documented but not able to go hunting for it at the moment.

David J.

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