Horton

Re: INET operators and NOT

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tomas Cerha <t.cerha@sh.cvut.cz>, pgsql-bugs@postgresql.org
Date: 2000-06-01T22:46:36Z
Lists: pgsql-bugs, pgsql-hackers 
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