Looks like some ORDER BY statements would be useful.
*** ./expected/inet.out Sat Jun 16 22:05:20 2001
--- ./results/inet.out Wed Jan 15 10:18:40 2003
***************
*** 193,212 **** select * from inet_tbl where i<<'192.168.1.0/24'::cidr; c | i
----------------+------------------ 192.168.1.0/24 | 192.168.1.0/25 192.168.1.0/24 | 192.168.1.255/25
- 192.168.1.0/24 | 192.168.1.226 (3 rows) select * from inet_tbl where i<<='192.168.1.0/24'::cidr; c |
i ----------------+------------------
- 192.168.1.0/24 | 192.168.1.0/24 192.168.1.0/24 | 192.168.1.226/24
! 192.168.1.0/24 | 192.168.1.255/24 192.168.1.0/24 | 192.168.1.0/25 192.168.1.0/24 | 192.168.1.255/25
- 192.168.1.0/24 | 192.168.1.226 (6 rows) set enable_seqscan to on;
--- 193,212 ---- select * from inet_tbl where i<<'192.168.1.0/24'::cidr; c | i
----------------+------------------
+ 192.168.1.0/24 | 192.168.1.226 192.168.1.0/24 | 192.168.1.0/25 192.168.1.0/24 | 192.168.1.255/25 (3 rows) select
*from inet_tbl where i<<='192.168.1.0/24'::cidr; c | i
----------------+------------------ 192.168.1.0/24 | 192.168.1.226/24
! 192.168.1.0/24 | 192.168.1.226
! 192.168.1.0/24 | 192.168.1.0/24 192.168.1.0/24 | 192.168.1.0/25
+ 192.168.1.0/24 | 192.168.1.255/24 192.168.1.0/24 | 192.168.1.255/25 (6 rows) set enable_seqscan to on;
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc