Determining if two subnets intersect

From: Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
To: pgsql-sql(at)postgresql(dot)org
Subject: Determining if two subnets intersect
Date: 2001-07-23 16:56:45
Message-ID: tgn15v8tyq.fsf@mercury.rus.uni-stuttgart.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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)?

--
Florian Weimer Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE
University of Stuttgart http://cert.uni-stuttgart.de/
RUS-CERT +49-711-685-5973/fax +49-711-685-5898

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Giles Lean 2001-07-23 17:03:34 Re: Full-text Indexing and Primary Keys
Previous Message Chris Ruprecht 2001-07-23 16:28:08 Re: Full-text Indexing and Primary Keys