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 possible for two
CIDR subnets to overlap if one contains the other. So you could
check with
A <<= B OR B <<= A
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
