Scott Brunza <scottso@xxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
