diff options
| author | Bruce Momjian <bruce@momjian.us> | 2015-03-21 21:50:03 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2015-03-21 21:50:03 -0400 |
| commit | 9d61b9953c1489cbb458ca70013cf5fca1bb7710 (patch) | |
| tree | 57e10b51d9ef5e203bdbbbcd125efe476281e325 /src | |
| parent | cc0d90b73b2e6dd2f301d46818a7265742c41a14 (diff) | |
| download | postgresql-9d61b9953c1489cbb458ca70013cf5fca1bb7710.tar.gz postgresql-9d61b9953c1489cbb458ca70013cf5fca1bb7710.zip | |
to_char(float4/8): don't print "junk" digits
Commit cc0d90b73b2e6dd2f301d46818a7265742c41a14 also avoids printing
junk digits, which are digits that are beyond the precision of the
underlying type.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/numeric.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/numeric.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out index 46b0c72b6a3..a4d0161923f 100644 --- a/src/test/regress/expected/numeric.out +++ b/src/test/regress/expected/numeric.out @@ -1539,7 +1539,7 @@ SELECT to_char(float8 '1.123456789123456789', '9.' || repeat('9', 55)); (1 row) SELECT to_char(float8 '1999999999999999999999999999999999999999999999.123456789123456789', - repeat('9', 50) || '.' || repeat('9', 50)); + repeat('9', 50) || '.' || repeat('9', 50)); to_char -------------------------------------------------------------------------------------------------------- 1999999999999990000000000000000000000000000000.00000000000000000000000000000000000000000000000000 diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql index a6301eab0a4..95c2203821a 100644 --- a/src/test/regress/sql/numeric.sql +++ b/src/test/regress/sql/numeric.sql @@ -870,7 +870,7 @@ SELECT to_char(float8 '1e20','999999999999999999999D9'); SELECT to_char(1e20, '999999999999999999999D9'); SELECT to_char(float8 '1.123456789123456789', '9.' || repeat('9', 55)); SELECT to_char(float8 '1999999999999999999999999999999999999999999999.123456789123456789', - repeat('9', 50) || '.' || repeat('9', 50)); + repeat('9', 50) || '.' || repeat('9', 50)); SELECT to_char(float8 '0.1', '9D' || repeat('9', 1000)); SELECT to_char(int4 '1', '9D' || repeat('9', 1000) || 'EEEE'); SELECT to_char(float4 '1', '9D' || repeat('9', 1000) || 'EEEE'); |