aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2005-03-26 02:14:43 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2005-03-26 02:14:43 +0000
commit58a02c99058f4827709a82b540cc07cbb1fba0e7 (patch)
treeec850079ac417c322c300e34721729e72a7c3f1a /src
parentfccde77ecb25c7f41e1b43b94892db5ce015eb42 (diff)
downloadpostgresql-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.out2
-rw-r--r--src/test/regress/sql/rules.sql2
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