diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-08-10 18:29:27 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-08-10 18:29:27 +0000 |
| commit | e61fd4ac7414a52714c3288889cc754d2e11c4a8 (patch) | |
| tree | a3bf339b96dc1d3f5fde9c2fdb7b8d03efdd6b95 /src/test | |
| parent | 933b17b663f06bd5bbe24e8e12044a844fd79bbf (diff) | |
| download | postgresql-e61fd4ac7414a52714c3288889cc754d2e11c4a8.tar.gz postgresql-e61fd4ac7414a52714c3288889cc754d2e11c4a8.zip | |
Support EEEE (scientific notation) in to_char().
Pavel Stehule, Brendan Jurd
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/numeric.out | 15 | ||||
| -rw-r--r-- | src/test/regress/sql/numeric.sql | 1 |
2 files changed, 16 insertions, 0 deletions
diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out index a3b631aabe0..857e1d83198 100644 --- a/src/test/regress/expected/numeric.out +++ b/src/test/regress/expected/numeric.out @@ -1139,6 +1139,21 @@ SELECT '' AS to_char_22, to_char(val, 'FM9999999999999999.999999999999999') FROM | -24926804.04504742 (10 rows) +SELECT '' AS to_char_23, to_char(val, '9.999EEEE') FROM num_data; + to_char_23 | to_char +------------+------------ + | 0.000e+00 + | 0.000e+00 + | -3.434e+07 + | 4.310e+00 + | 7.799e+06 + | 1.640e+04 + | 9.390e+04 + | -8.303e+07 + | 7.488e+04 + | -2.493e+07 +(10 rows) + -- TO_NUMBER() -- SELECT '' AS to_number_1, to_number('-34,338,492', '99G999G999'); diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql index 9fd6bba31ee..8814bba486b 100644 --- a/src/test/regress/sql/numeric.sql +++ b/src/test/regress/sql/numeric.sql @@ -762,6 +762,7 @@ SELECT '' AS to_char_19, to_char(val, 'FMS 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 SELECT '' AS to_char_20, to_char(val, E'99999 "text" 9999 "9999" 999 "\\"text between quote marks\\"" 9999') FROM num_data; SELECT '' AS to_char_21, to_char(val, '999999SG9999999999') FROM num_data; SELECT '' AS to_char_22, to_char(val, 'FM9999999999999999.999999999999999') FROM num_data; +SELECT '' AS to_char_23, to_char(val, '9.999EEEE') FROM num_data; -- TO_NUMBER() -- |