diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2016-01-05 19:02:13 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2016-01-05 19:02:13 -0300 |
| commit | abb1733922f3ff17a514499883a549f8bd03af44 (patch) | |
| tree | e84ec7b8ca4bf1620476b9416d1f3affdf6bf494 /src/test/regress/sql/numeric.sql | |
| parent | 419400c5da738d86c87e903a3d1924ff365bf203 (diff) | |
| download | postgresql-abb1733922f3ff17a514499883a549f8bd03af44.tar.gz | |
Add scale(numeric)
Author: Marko Tiikkaja
Diffstat (limited to 'src/test/regress/sql/numeric.sql')
| -rw-r--r-- | src/test/regress/sql/numeric.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql index 0a4d1cb1d2..fc472187d8 100644 --- a/src/test/regress/sql/numeric.sql +++ b/src/test/regress/sql/numeric.sql @@ -983,3 +983,17 @@ select log(1.23e-89, 6.4689e45); select log(0.99923, 4.58934e34); select log(1.000016, 8.452010e18); select log(3.1954752e47, 9.4792021e-73); + +-- +-- Tests for scale() +-- + +select scale(numeric 'NaN'); +select scale(NULL::numeric); +select scale(1.12); +select scale(0); +select scale(0.00); +select scale(1.12345); +select scale(110123.12475871856128); +select scale(-1123.12471856128); +select scale(-13.000000000000000); |