diff options
Diffstat (limited to 'src/test/regress/sql/money.sql')
-rw-r--r-- | src/test/regress/sql/money.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/test/regress/sql/money.sql b/src/test/regress/sql/money.sql index 37b9ecce1fc..5e746286c90 100644 --- a/src/test/regress/sql/money.sql +++ b/src/test/regress/sql/money.sql @@ -1,6 +1,8 @@ -- -- MONEY -- +-- Note that we assume lc_monetary has been set to C. +-- CREATE TABLE money_data (m money); @@ -122,6 +124,8 @@ SELECT (-1234567890)::int4::money; SELECT (-12345678901234567)::int8::money; SELECT (-12345678901234567)::numeric::money; --- Cast from money +-- Cast from money to numeric SELECT '12345678901234567'::money::numeric; SELECT '-12345678901234567'::money::numeric; +SELECT '92233720368547758.07'::money::numeric; +SELECT '-92233720368547758.08'::money::numeric; |