Search Postgresql Archives

Re: ip contained within subnet

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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

Yes, that did it.  I guess I'll have to hit the books again to fully grok what you did.  THANKS!


--- Let us all bask in television's warm glowing warming glow ---
Scott Brunza           860.326.3637         scottso@xxxxxxxxxxxxx

This e-mail and any files transmitted with it may be  proprietary
and are  intended solely for the use of the  individual or entity
to whom they are addressed.  If you have received this  e-mail in
error please notify the sender.

<<attachment: smime.p7s>>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux