Scott Brunza <[email protected]> writes:
> select a.ip, b.foo from tablea a, tableb, b where a.id=b.id and a.ip ! <<=
> (select network from assets where network is not null)
This is definitely not legal SQL. I think you are looking for something
like
select a.ip, b.foo from tablea a, tableb b where a.id=b.id and
not (a.ip <<= any (select network from assets where network is not null))
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
