diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-03-26 02:14:43 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-03-26 02:14:43 +0000 |
commit | 58a02c99058f4827709a82b540cc07cbb1fba0e7 (patch) | |
tree | ec850079ac417c322c300e34721729e72a7c3f1a /src | |
parent | fccde77ecb25c7f41e1b43b94892db5ce015eb42 (diff) | |
download | postgresql-58a02c99058f4827709a82b540cc07cbb1fba0e7.tar.gz postgresql-58a02c99058f4827709a82b540cc07cbb1fba0e7.zip |
Add another ORDER BY to rules test to eliminate platform-specific
output ordering.
Diffstat (limited to 'src')
-rw-r--r-- | src/test/regress/expected/rules.out | 2 | ||||
-rw-r--r-- | src/test/regress/sql/rules.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index 837c46b55ad..0d46494596c 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -1121,7 +1121,7 @@ SELECT * FROM shoelace_log ORDER BY sl_name; SELECT * FROM shoelace_obsolete WHERE sl_avail = 0; insert into shoelace values ('sl9', 0, 'pink', 35.0, 'inch', 0.0); insert into shoelace values ('sl10', 1000, 'magenta', 40.0, 'inch', 0.0); -SELECT * FROM shoelace_obsolete; +SELECT * FROM shoelace_obsolete ORDER BY sl_len_cm; sl_name | sl_avail | sl_color | sl_len | sl_unit | sl_len_cm ------------+----------+------------+--------+----------+----------- sl9 | 0 | pink | 35 | inch | 88.9 diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql index 4651090a9dc..cd0ae43c3e6 100644 --- a/src/test/regress/sql/rules.sql +++ b/src/test/regress/sql/rules.sql @@ -679,7 +679,7 @@ SELECT * FROM shoelace_log ORDER BY sl_name; insert into shoelace values ('sl9', 0, 'pink', 35.0, 'inch', 0.0); insert into shoelace values ('sl10', 1000, 'magenta', 40.0, 'inch', 0.0); -SELECT * FROM shoelace_obsolete; +SELECT * FROM shoelace_obsolete ORDER BY sl_len_cm; SELECT * FROM shoelace_candelete; DELETE FROM shoelace WHERE EXISTS |