diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2020-01-06 12:13:53 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2020-01-06 12:13:53 -0500 |
| commit | 20d6225d1656102534a73d9675bc531ff0e5203b (patch) | |
| tree | 640f43672e6f6ab5140450ad2a5d962d319c679d /doc/src | |
| parent | b9c130a1fdf16cd99afb390c186d19acaea7d132 (diff) | |
| download | postgresql-20d6225d1656102534a73d9675bc531ff0e5203b.tar.gz postgresql-20d6225d1656102534a73d9675bc531ff0e5203b.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 32 |
1 files changed, 30 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 57a1539506d..4b42f128625 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -921,6 +921,20 @@ <row> <entry> <indexterm> + <primary>min_scale</primary> + </indexterm> + <literal><function>min_scale(<type>numeric</type>)</function></literal> + </entry> + <entry><type>integer</type></entry> + <entry>minimum scale (number of fractional decimal digits) needed + to represent the supplied value</entry> + <entry><literal>min_scale(8.4100)</literal></entry> + <entry><literal>2</literal></entry> + </row> + + <row> + <entry> + <indexterm> <primary>mod</primary> </indexterm> <literal><function>mod(<parameter>y</parameter>, @@ -1011,8 +1025,8 @@ </entry> <entry><type>integer</type></entry> <entry>scale of the argument (the number of decimal digits in the fractional part)</entry> - <entry><literal>scale(8.41)</literal></entry> - <entry><literal>2</literal></entry> + <entry><literal>scale(8.4100)</literal></entry> + <entry><literal>4</literal></entry> </row> <row> @@ -1044,6 +1058,20 @@ <row> <entry> <indexterm> + <primary>trim_scale</primary> + </indexterm> + <literal><function>trim_scale(<type>numeric</type>)</function></literal> + </entry> + <entry><type>numeric</type></entry> + <entry>reduce the scale (number of fractional decimal digits) by + removing trailing zeroes</entry> + <entry><literal>trim_scale(8.4100)</literal></entry> + <entry><literal>8.41</literal></entry> + </row> + + <row> + <entry> + <indexterm> <primary>trunc</primary> </indexterm> <literal><function>trunc(<type>dp</type> or <type>numeric</type>)</function></literal> |