diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1997-09-13 03:16:53 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1997-09-13 03:16:53 +0000 |
| commit | aeecb4e5050cde921ff4128c59a83bd58263ea38 (patch) | |
| tree | 7ae36dad32bdd6dad5bfa90490619021a1f73162 /src | |
| parent | bc85dbf893c5d92d11f5dc43e527be26f927b516 (diff) | |
| download | postgresql-aeecb4e5050cde921ff4128c59a83bd58263ea38.tar.gz postgresql-aeecb4e5050cde921ff4128c59a83bd58263ea38.zip | |
Add a few tests for unary minus syntax.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/sql/int4.sql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/src/test/regress/sql/int4.sql b/src/test/regress/sql/int4.sql index 884e1e46367..6a32ee88d4d 100644 --- a/src/test/regress/sql/int4.sql +++ b/src/test/regress/sql/int4.sql @@ -73,10 +73,19 @@ SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT4_TBL i; SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT4_TBL i; - -- -- more complex expressions -- + +-- variations on unary minus parsing +SELECT -2+3 AS one; + +SELECT 4-2 AS two; + +SELECT 2- -1 AS three; + +SELECT 2 - -2 AS four; + SELECT '2'::int2 * '2'::int2 = '16'::int2 / '4'::int2 AS true; SELECT '2'::int4 * '2'::int2 = '16'::int2 / '4'::int4 AS true; |