Rod Taylor <rbt@rbt.ca> writes:
> Index Scan using inet_idx1 on inet_tbl (cost=3D0.00..4.68 rows=3D7
> width=3D64)
> Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <=3D
> '192.168.1.255'::inet))
> Filter: (i << '192.168.1.0/24'::inet)
> (3 rows)
That's the expected plan ...
> regression=3D# select * from inet_tbl where i<<'192.168.1.0/24'::cidr;
> c | i =20
> ----------------+------------------
> 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)
... and that's the expected result. So why'd you get a different result
while running the regression test? Curiouser and curiouser...
regards, tom lane