diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-01-15 20:01:01 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-01-15 20:01:01 +0000 |
| commit | 4b874036c27ee1ba9995b3ea9a29e09bed26e4ae (patch) | |
| tree | 273f81c5d68d34e65f2508c5e65255b84ecfc75d | |
| parent | de97072e3c88e104a55b0d5c67477f1b0097c003 (diff) | |
| download | postgresql-4b874036c27ee1ba9995b3ea9a29e09bed26e4ae.tar.gz postgresql-4b874036c27ee1ba9995b3ea9a29e09bed26e4ae.zip | |
Back out ORDER BY addition to Inet, for Tom.
| -rw-r--r-- | src/test/regress/expected/inet.out | 4 | ||||
| -rw-r--r-- | src/test/regress/sql/inet.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/inet.out b/src/test/regress/expected/inet.out index 8c4b545687f..59983f5f23c 100644 --- a/src/test/regress/expected/inet.out +++ b/src/test/regress/expected/inet.out @@ -190,7 +190,7 @@ SELECT '' AS ten, set_masklen(inet(text(i)), 24) FROM INET_TBL; -- check that index works correctly CREATE INDEX inet_idx1 ON inet_tbl(i); SET enable_seqscan TO off; -SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr ORDER BY c,i; +SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i ----------------+------------------ 192.168.1.0/24 | 192.168.1.0/25 @@ -198,7 +198,7 @@ SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr ORDER BY c,i; 192.168.1.0/24 | 192.168.1.226 (3 rows) -SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr ORDER BY c,i; +SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr; c | i ----------------+------------------ 192.168.1.0/24 | 192.168.1.0/24 diff --git a/src/test/regress/sql/inet.sql b/src/test/regress/sql/inet.sql index ca11f49495b..d62337d4d42 100644 --- a/src/test/regress/sql/inet.sql +++ b/src/test/regress/sql/inet.sql @@ -56,8 +56,8 @@ SELECT '' AS ten, set_masklen(inet(text(i)), 24) FROM INET_TBL; -- check that index works correctly CREATE INDEX inet_idx1 ON inet_tbl(i); SET enable_seqscan TO off; -SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr ORDER BY c,i; -SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr ORDER BY c,i; +SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; +SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr; SET enable_seqscan TO on; DROP INDEX inet_idx1; |