Request a Demo
Home   >   mailing lists

inet regression test - Mailing list pgsql-hackers

From Rod Taylor
Subject inet regression test
Date
Msg-id 1042646725.61110.19.camel@jester
Whole thread Raw
Responses Re: inet regression test
Re: inet regression test
List pgsql-hackers
Tree view 
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 <[email protected]>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: UNION result
Next
From: Tom Lane
Date:
Subject: Re: UNION result