diff options
| author | Pavan Deolasee | 2017-06-28 08:55:38 +0000 |
|---|---|---|
| committer | Pavan Deolasee | 2017-06-28 08:55:38 +0000 |
| commit | 78c7f94bd6bbebb2d4e5e6f91fc2de13f5c973c4 (patch) | |
| tree | 14307df5f77ad2fdc24fbe22660afbb992267661 | |
| parent | 3331290a57003542efe9fd42005e31aca6d6f852 (diff) | |
Rearrange individual tests in the 'money' test case
Commands in the sql file had got out of order causing failures. Bringing them
in order is now passing the test case.
| -rw-r--r-- | src/test/regress/sql/money.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/sql/money.sql b/src/test/regress/sql/money.sql index 2e96592e1a..da42f7a7cd 100644 --- a/src/test/regress/sql/money.sql +++ b/src/test/regress/sql/money.sql @@ -120,6 +120,11 @@ SELECT 12345678901234567::int8::money; SELECT 12345678901234567::numeric::money; SELECT (-1234567890)::int4::money; SELECT (-12345678901234567)::int8::money; +SELECT (-12345678901234567)::numeric::money; + +-- Cast from money +SELECT '12345678901234567'::money::numeric; +SELECT '-12345678901234567'::money::numeric; INSERT INTO money_data VALUES ('$223.459'); INSERT INTO money_data VALUES ('$323.459'); @@ -136,8 +141,3 @@ INSERT INTO money_data2 VALUES (5, '$523.459'); SELECT sum(m) FROM money_data2; DROP TABLE money_data2; -SELECT (-12345678901234567)::numeric::money; - --- Cast from money -SELECT '12345678901234567'::money::numeric; -SELECT '-12345678901234567'::money::numeric; |