Re: ip contained within subnet

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