From a938f32a5af48914dce33b963cbd325fb0e186fd Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 18 Jul 2002 17:11:49 +0000 Subject: [PATCH] New depend code auto-drops sequence, fix copy2.out. --- src/test/regress/expected/copy2.out | 1 - src/test/regress/expected/select.out | 147 --------------------------- 2 files changed, 148 deletions(-) diff --git a/src/test/regress/expected/copy2.out b/src/test/regress/expected/copy2.out index 51444c0e60..c84edb9864 100644 --- a/src/test/regress/expected/copy2.out +++ b/src/test/regress/expected/copy2.out @@ -40,6 +40,5 @@ COPY x TO stdout; 4 4 stuff test_4 after trigger fired 5 5 stuff test_5 after trigger fired DROP TABLE x; -DROP SEQUENCE x_a_seq; DROP FUNCTION fn_x_before(); DROP FUNCTION fn_x_after(); diff --git a/src/test/regress/expected/select.out b/src/test/regress/expected/select.out index 582c893ca5..7974d141c5 100644 --- a/src/test/regress/expected/select.out +++ b/src/test/regress/expected/select.out @@ -430,150 +430,3 @@ SELECT p.name, p.age FROM person* p ORDER BY age using >, name; mary | 8 (58 rows) --- --- Test between syntax --- -SELECT 2 BETWEEN 1 AND 3; - ?column? ----------- - t -(1 row) - -SELECT 2 BETWEEN 3 AND 1; - ?column? ----------- - f -(1 row) - -SELECT 2 BETWEEN ASYMMETRIC 1 AND 3; - ?column? ----------- - t -(1 row) - -SELECT 2 BETWEEN ASYMMETRIC 3 AND 1; - ?column? ----------- - f -(1 row) - -SELECT 2 BETWEEN SYMMETRIC 1 AND 3; - ?column? ----------- - t -(1 row) - -SELECT 2 BETWEEN SYMMETRIC 3 AND 1; - ?column? ----------- - t -(1 row) - -SELECT 2 NOT BETWEEN 1 AND 3; - ?column? ----------- - f -(1 row) - -SELECT 2 NOT BETWEEN 3 AND 1; - ?column? ----------- - t -(1 row) - -SELECT 2 NOT BETWEEN ASYMMETRIC 1 AND 3; - ?column? ----------- - f -(1 row) - -SELECT 2 NOT BETWEEN ASYMMETRIC 3 AND 1; - ?column? ----------- - t -(1 row) - -SELECT 2 NOT BETWEEN SYMMETRIC 1 AND 3; - ?column? ----------- - f -(1 row) - -SELECT 2 NOT BETWEEN SYMMETRIC 3 AND 1; - ?column? ----------- - f -(1 row) - -SELECT -4 BETWEEN -1 AND -3; - ?column? ----------- - f -(1 row) - -SELECT -4 BETWEEN -3 AND -1; - ?column? ----------- - f -(1 row) - -SELECT -4 BETWEEN ASYMMETRIC -1 AND -3; - ?column? ----------- - f -(1 row) - -SELECT -4 BETWEEN ASYMMETRIC -3 AND -1; - ?column? ----------- - f -(1 row) - -SELECT -4 BETWEEN SYMMETRIC -1 AND -3; - ?column? ----------- - f -(1 row) - -SELECT -4 BETWEEN SYMMETRIC -3 AND -1; - ?column? ----------- - f -(1 row) - -SELECT -4 NOT BETWEEN -1 AND -3; - ?column? ----------- - t -(1 row) - -SELECT -4 NOT BETWEEN -3 AND -1; - ?column? ----------- - t -(1 row) - -SELECT -4 NOT BETWEEN ASYMMETRIC -1 AND -3; - ?column? ----------- - t -(1 row) - -SELECT -4 NOT BETWEEN ASYMMETRIC -3 AND -1; - ?column? ----------- - t -(1 row) - -SELECT -4 NOT BETWEEN SYMMETRIC -1 AND -3; - ?column? ----------- - t -(1 row) - -SELECT -4 NOT BETWEEN SYMMETRIC -3 AND -1; - ?column? ----------- - t - (1 row) - -- 2.40.0