Scott Brunza <scottso@sonalysts.com> 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
isnot 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