diff options
| author | Tom Lane | 2004-10-28 18:55:08 +0000 |
|---|---|---|
| committer | Tom Lane | 2004-10-28 18:55:08 +0000 |
| commit | 319902dc8c736c54e7834440786037d9bfafccef (patch) | |
| tree | fa03ea9fb0a0b0874a9a0944d9e4c60315907ce7 /src/test | |
| parent | 5fef3c6ef06422ad1fc36985d8b244fb24115e7d (diff) | |
Fix to_number for the case of a trailing S.
Karel Zak
Diffstat (limited to 'src/test')
| -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 b95d79fb890..7d075a2a8ee 100644 --- a/src/test/regress/expected/numeric.out +++ b/src/test/regress/expected/numeric.out @@ -1191,7 +1191,7 @@ SELECT '' AS to_number_12, to_number('.01-', '99.99S'); | -0.01 (1 row) -SELECT '' AS to_number_13, to_number(' . 0 1 -', ' 9 9 . 9 9 S'); +SELECT '' AS to_number_13, to_number(' . 0 1-', ' 9 9 . 9 9 S'); to_number_13 | to_number --------------+----------- | -0.01 diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql index 06f9dfd749d..ffc16733390 100644 --- a/src/test/regress/sql/numeric.sql +++ b/src/test/regress/sql/numeric.sql @@ -760,7 +760,7 @@ SELECT '' AS to_number_9, to_number('.0', '99999999.99999999'); SELECT '' AS to_number_10, to_number('0', '99.99'); SELECT '' AS to_number_11, to_number('.-01', 'S99.99'); SELECT '' AS to_number_12, to_number('.01-', '99.99S'); -SELECT '' AS to_number_13, to_number(' . 0 1 -', ' 9 9 . 9 9 S'); +SELECT '' AS to_number_13, to_number(' . 0 1-', ' 9 9 . 9 9 S'); -- -- Input syntax |