Index: src/test/regress/expected/rules.out =================================================================== RCS file: /cvsroot/pgsql-server/src/test/regress/expected/rules.out,v retrieving revision 1.62 diff -c -c -r1.62 rules.out *** src/test/regress/expected/rules.out 2 Sep 2002 02:13:02 -0000 1.62 --- src/test/regress/expected/rules.out 2 Sep 2002 04:47:26 -0000 *************** *** 1002,1008 **** sl8 | 1 | brown | 40 | inch | 101.6 (8 rows) ! SELECT * FROM shoe_ready WHERE total_avail >= 2; shoename | sh_avail | sl_name | sl_avail | total_avail ------------+----------+------------+----------+------------- sh1 | 2 | sl1 | 5 | 2 --- 1002,1008 ---- sl8 | 1 | brown | 40 | inch | 101.6 (8 rows) ! SELECT * FROM shoe_ready WHERE total_avail >= 2 ORDER BY 1; shoename | sh_avail | sl_name | sl_avail | total_avail ------------+----------+------------+----------+------------- sh1 | 2 | sl1 | 5 | 2 Index: src/test/regress/sql/rules.sql =================================================================== RCS file: /cvsroot/pgsql-server/src/test/regress/sql/rules.sql,v retrieving revision 1.21 diff -c -c -r1.21 rules.sql *** src/test/regress/sql/rules.sql 2 Sep 2002 02:13:02 -0000 1.21 --- src/test/regress/sql/rules.sql 2 Sep 2002 04:47:29 -0000 *************** *** 585,591 **** -- SELECTs in doc SELECT * FROM shoelace ORDER BY sl_name; ! SELECT * FROM shoe_ready WHERE total_avail >= 2; CREATE TABLE shoelace_log ( sl_name char(10), -- shoelace changed --- 585,591 ---- -- SELECTs in doc SELECT * FROM shoelace ORDER BY sl_name; ! SELECT * FROM shoe_ready WHERE total_avail >= 2 ORDER BY 1; CREATE TABLE shoelace_log ( sl_name char(10), -- shoelace changed