Add functions min_scale(numeric) and trim_scale(numeric).
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 6 Jan 2020 17:13:53 +0000 (12:13 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 6 Jan 2020 17:13:53 +0000 (12:13 -0500)
commit20d6225d1656102534a73d9675bc531ff0e5203b
tree640f43672e6f6ab5140450ad2a5d962d319c679d
parentb9c130a1fdf16cd99afb390c186d19acaea7d132
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
doc/src/sgml/func.sgml
src/backend/utils/adt/numeric.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/regress/expected/numeric.out
src/test/regress/sql/numeric.sql