Re: inet regression test

OK, I have applied an patch to ORDER BY on those queries. I don't see
the ordering you have here, but this should fix it for you. I also
uppercased the keywords while I was in there.

---------------------------------------------------------------------------

Rod Taylor wrote:
-- Start of PGP signed section.
> 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(at)rbt(dot)ca>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc
-- End of PGP section, PGP failed!

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073