Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I still see this problem in 7.0.
You do? I don't:
regression=# SELECT * FROM a;
ip
----------
10.1.1.1
10.1.1.2
10.2.1.2
10.2.1.1
(4 rows)
regression=# SELECT * FROM a WHERE ip<<'10.1/16';
ip
----------
10.1.1.1
10.1.1.2
(2 rows)
regression=# SELECT * FROM a WHERE NOT ip<<'10.1/16';
ip
----------
10.2.1.2
10.2.1.1
(2 rows)
regression=#
regards, tom lane