X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9A132D9C53 for ; Wed, 21 Sep 2005 16:43:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82391-05 for ; Wed, 21 Sep 2005 19:43:14 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 34E2BD9CB5 for ; Wed, 21 Sep 2005 16:43:14 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j8LJhEdH020224; Wed, 21 Sep 2005 15:43:14 -0400 (EDT) To: Bruno Wolff III Cc: Sean Davis , pgsql-sql@postgresql.org Subject: Re: R-tree and start/end queries In-reply-to: <20050921183837.GA27439@wolff.to> References: <20050921183837.GA27439@wolff.to> Comments: In-reply-to Bruno Wolff III message dated "Wed, 21 Sep 2005 13:38:37 -0500" Date: Wed, 21 Sep 2005 15:43:14 -0400 Message-ID: <20223.1127331794@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/191 X-Sequence-Number: 22738 Bruno Wolff III writes: > There is a built in type for line segments that uses floating point. That > will probably be usable by you directly unless the integers can can large > enough that precision is a problem. There is an overlaps operator for the > geometric types that could be used to answer your sample questions. However, there's no built-in rtree opclass for that datatype, so he'd still be stuck with respect to getting indexing support for overlaps queries. I think the contrib/seg datatype might help, though the precision issue is still a possible problem. regards, tom lane