pgsql: Add functions min_scale(numeric) and trim_scale(numeric). - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Add functions min_scale(numeric) and trim_scale(numeric).
Date
Msg-id E1ioVxR-0001rT-9G@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add functions min_scale(numeric) and trim_scale(numeric).

These allow better control of trailing zeroes in numeric values.

Pavel Stehule, based on an old proposal of Marko Tiikkaja's;
review by Karl Pinc

Discussion: https://postgr.es/m/CAFj8pRDjs-navGASeF0Wk74N36YGFJ+v=Ok9_knRa7vDc-qugg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/20d6225d1656102534a73d9675bc531ff0e5203b

Modified Files
--------------
doc/src/sgml/func.sgml                |  32 ++++++++-
src/backend/utils/adt/numeric.c       |  91 ++++++++++++++++++++++++
src/include/catalog/catversion.h      |   2 +-
src/include/catalog/pg_proc.dat       |   7 ++
src/test/regress/expected/numeric.out | 126 ++++++++++++++++++++++++++++++++++
src/test/regress/sql/numeric.sql      |  30 ++++++++
6 files changed, 285 insertions(+), 3 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Have logical replication subscriber fire column triggers
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Remove support for OpenSSL 0.9.8 and 1.0.0