Postgres Pro
Downloads
Home   >   mailing lists

Re: ip contained within subnet - Mailing list pgsql-general

From Scott Brunza
Subject Re: ip contained within subnet
Date
Msg-id F8F0BAA8-F2FF-4413-93B6-996242F8BAD2@sonalysts.com
Whole thread Raw
In response to Re: ip contained within subnet  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

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@sonalysts.com

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

pgsql-general by date:

Previous
From: Vikram Patil
Date:
Subject: Re: Windows 2003 server installation issue
Next
From: Sam Nelson
Date:
Subject: Re: Missing Toast Chunk