Rod Taylor <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to