pgsql: Add functions min_scale(numeric) and trim_scale(numeric).

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add functions min_scale(numeric) and trim_scale(numeric).
Date: 2020-01-06 17:14:25
Message-ID: E1ioVxR-0001rT-9G@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Christoph Berg 2020-01-06 19:13:03 Re: pgsql: Add basic TAP tests for psql's tab-completion logic.
Previous Message Tom Lane 2020-01-06 15:15:19 Re: pgsql: Add basic TAP tests for psql's tab-completion logic.