Request a Demo
Home   >   mailing lists

Re: Numeric Type Precision Not Respected in Function or Procedure Arguments - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Numeric Type Precision Not Respected in Function or Procedure Arguments
Date
Msg-id CAKFQuwZ9vp+Ww2UAcrP2CsQ5Ye8CKD62R4FEts_aHLSLOv1sjw@mail.gmail.com
Whole thread Raw
In response to Numeric Type Precision Not Respected in Function or Procedure Arguments  (Aaron Ackerman <aackerman@goodmorning.com>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Numeric Type Precision Not Respected in Function or Procedure Arguments
Next
From: PG Bug reporting form
Date:
Subject: BUG #19061: I downloaded version 17 of postgreSQL and it was lagging very much