Re: INET operators and NOT

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

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026