Re: INET operators and NOT

Sorry, I got the 2's and 1's mixed up. Yes, fixed.

> 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
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026