diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2016-12-28 12:00:00 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-01-17 12:36:02 -0500 |
| commit | 323b96aa34239b5a8fe773d614a6ee50d731a683 (patch) | |
| tree | 788bf7017160ec1c735d55139bd7ed5203358168 /src/test | |
| parent | 09e35315ccafb83c52da2e0fd6a0a9be410ce6a4 (diff) | |
| download | postgresql-323b96aa34239b5a8fe773d614a6ee50d731a683.tar.gz postgresql-323b96aa34239b5a8fe773d614a6ee50d731a683.zip | |
Register missing money operators in system catalogs
The operators money*int8, int8*money, and money/int8 were implemented in
code but not registered in pg_operator or pg_proc.
Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com>
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/money.out | 18 | ||||
| -rw-r--r-- | src/test/regress/sql/money.sql | 3 |
2 files changed, 21 insertions, 0 deletions
diff --git a/src/test/regress/expected/money.out b/src/test/regress/expected/money.out index a05fdd9f422..0cc69f925f5 100644 --- a/src/test/regress/expected/money.out +++ b/src/test/regress/expected/money.out @@ -69,6 +69,24 @@ SELECT m / 2::int2 FROM money_data; $61.50 (1 row) +SELECT m * 2::int8 FROM money_data; + ?column? +---------- + $246.00 +(1 row) + +SELECT 2::int8 * m FROM money_data; + ?column? +---------- + $246.00 +(1 row) + +SELECT m / 2::int8 FROM money_data; + ?column? +---------- + $61.50 +(1 row) + SELECT m * 2::float8 FROM money_data; ?column? ---------- diff --git a/src/test/regress/sql/money.sql b/src/test/regress/sql/money.sql index 9e89e32d773..f5a92f2a695 100644 --- a/src/test/regress/sql/money.sql +++ b/src/test/regress/sql/money.sql @@ -16,6 +16,9 @@ SELECT m / 2 FROM money_data; SELECT m * 2::int2 FROM money_data; SELECT 2::int2 * m FROM money_data; SELECT m / 2::int2 FROM money_data; +SELECT m * 2::int8 FROM money_data; +SELECT 2::int8 * m FROM money_data; +SELECT m / 2::int8 FROM money_data; SELECT m * 2::float8 FROM money_data; SELECT 2::float8 * m FROM money_data; SELECT m / 2::float8 FROM money_data; |