Re: [SQL] Determining if two subnets intersect

2001-07-25 Thread Florian Weimer
Tom Lane <[EMAIL PROTECTED]> writes: > Florian Weimer <[EMAIL PROTECTED]> writes: > > Is there some efficient PostgreSQL expression which is true if and > > only if two subnets (given as values of type cidr) have non-empty > > intersection (even if the intersection is not a CIDR network)? > > Ma

Re: [SQL] Determining if two subnets intersect

2001-07-24 Thread Tom Lane
Florian Weimer <[EMAIL PROTECTED]> writes: > Is there some efficient PostgreSQL expression which is true if and > only if two subnets (given as values of type cidr) have non-empty > intersection (even if the intersection is not a CIDR network)? Maybe I'm missing something, but ISTM it's only poss