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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Aaron Ackerman <aackerman(at)goodmorning(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Numeric Type Precision Not Respected in Function or Procedure Arguments
Date: 2025-09-22 21:33:45
Message-ID: CAKFQuwZ9vp+Ww2UAcrP2CsQ5Ye8CKD62R4FEts_aHLSLOv1sjw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Monday, September 22, 2025, Aaron Ackerman <aackerman(at)goodmorning(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Tom Lane 2025-09-22 21:31:07 Re: Numeric Type Precision Not Respected in Function or Procedure Arguments