diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-07-18 17:11:49 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-07-18 17:11:49 +0000 |
| commit | a938f32a5af48914dce33b963cbd325fb0e186fd (patch) | |
| tree | a403356b74e619f4781c8c1310298a724ac80de2 /src | |
| parent | 11333426f103bedef311d1dd88b62176276b8544 (diff) | |
| download | postgresql-a938f32a5af48914dce33b963cbd325fb0e186fd.tar.gz postgresql-a938f32a5af48914dce33b963cbd325fb0e186fd.zip | |
New depend code auto-drops sequence, fix copy2.out.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/copy2.out | 1 | ||||
| -rw-r--r-- | src/test/regress/expected/select.out | 147 |
2 files changed, 0 insertions, 148 deletions
diff --git a/src/test/regress/expected/copy2.out b/src/test/regress/expected/copy2.out index 51444c0e606..c84edb9864f 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 582c893ca56..7974d141c54 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) - |