diff options
Diffstat (limited to 'src/test/regress/sql/select.sql')
-rw-r--r-- | src/test/regress/sql/select.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/src/test/regress/sql/select.sql b/src/test/regress/sql/select.sql index ee9389dc597..6a8e3bb02e9 100644 --- a/src/test/regress/sql/select.sql +++ b/src/test/regress/sql/select.sql @@ -103,3 +103,31 @@ SELECT p.name, p.age FROM person* p; -- SELECT p.name, p.age FROM person* p ORDER BY age using >, name; +-- +-- Test between syntax +-- +SELECT 2 BETWEEN 1 AND 3; +SELECT 2 BETWEEN 3 AND 1; +SELECT 2 BETWEEN ASYMMETRIC 1 AND 3; +SELECT 2 BETWEEN ASYMMETRIC 3 AND 1; +SELECT 2 BETWEEN SYMMETRIC 1 AND 3; +SELECT 2 BETWEEN SYMMETRIC 3 AND 1; +SELECT 2 NOT BETWEEN 1 AND 3; +SELECT 2 NOT BETWEEN 3 AND 1; +SELECT 2 NOT BETWEEN ASYMMETRIC 1 AND 3; +SELECT 2 NOT BETWEEN ASYMMETRIC 3 AND 1; +SELECT 2 NOT BETWEEN SYMMETRIC 1 AND 3; +SELECT 2 NOT BETWEEN SYMMETRIC 3 AND 1; +SELECT -4 BETWEEN -1 AND -3; +SELECT -4 BETWEEN -3 AND -1; +SELECT -4 BETWEEN ASYMMETRIC -1 AND -3; +SELECT -4 BETWEEN ASYMMETRIC -3 AND -1; +SELECT -4 BETWEEN SYMMETRIC -1 AND -3; +SELECT -4 BETWEEN SYMMETRIC -3 AND -1; +SELECT -4 NOT BETWEEN -1 AND -3; +SELECT -4 NOT BETWEEN -3 AND -1; +SELECT -4 NOT BETWEEN ASYMMETRIC -1 AND -3; +SELECT -4 NOT BETWEEN ASYMMETRIC -3 AND -1; +SELECT -4 NOT BETWEEN SYMMETRIC -1 AND -3; +SELECT -4 NOT BETWEEN SYMMETRIC -3 AND -1; + |