Received: from mercury.rus.uni-stuttgart.de (mercury.rus.uni-stuttgart.de [129.69.1.226]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6NGwof58952 for ; Mon, 23 Jul 2001 12:58:51 -0400 (EDT) (envelope-from Florian.Weimer@RUS.Uni-Stuttgart.DE) Received: from rusfw by mercury.rus.uni-stuttgart.de with local (Exim 3.22 #1) id 15Oj0f-0002RB-00 for pgsql-sql@postgresql.org; Mon, 23 Jul 2001 18:56:45 +0200 To: pgsql-sql@postgresql.org Subject: Determining if two subnets intersect From: Florian Weimer Date: 23 Jul 2001 18:56:45 +0200 Message-ID: Lines: 8 User-Agent: Gnus/5.090001 (Oort Gnus v0.01) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200107/317 X-Sequence-Number: 4130 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.Weimer@RUS.Uni-Stuttgart.DE University of Stuttgart http://cert.uni-stuttgart.de/ RUS-CERT +49-711-685-5973/fax +49-711-685-5898