Received: from www.propertykey.com (propertykey.com [206.196.37.193]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3HHYju86300 for ; Tue, 17 Apr 2001 13:34:45 -0400 (EDT) (envelope-from jeff@propertykey.com) Received: from propertykey.com (gotojail.propertykey.com [206.196.37.197]) by www.propertykey.com (8.9.3/8.9.3) with ESMTP id MAA21281; Tue, 17 Apr 2001 12:34:41 -0500 Message-ID: <3ADC7E8F.7569BABD@propertykey.com> Date: Tue, 17 Apr 2001 12:34:07 -0500 From: Jeff Hoffmann Organization: PropertyKey.com X-Mailer: Mozilla 4.75 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@postgresql.org Subject: Re: RTREE on points References: <9bbtqv$688$1@news.tht.net> <3ADAFF38.E7147C8D@propertykey.com> <008f01c0c68a$b6651c00$2285fd3e@julian> <3ADB65F4.6F83A1E7@propertykey.com> <19849.987464946@sss.pgh.pa.us> <3ADC6B1D.5C4C2D71@propertykey.com> <24276.987525349@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/272 X-Sequence-Number: 2625 Tom Lane wrote: > > I don't recall any such thing having been removed, but it does seem > peculiar that there are no GIST opclasses in the standard distribution. > How the heck did the GIST index code get developed/tested without some > opclasses? doing some digging at berkeley, i found the original pggist patch file that created the gist access method & gist_box_ops opclass (among others). i'm assuming that patch was the basis for what was originally introduced, so i don't know why it didn't get included with everything else. it looks like there are a lot of calls to internal postgresql box comparison functions that would need to get converted to the new calling convention, but it should be pretty straightforward to get it to work with a recent version of postgresql. it does seem pretty silly to have it in there if you don't have any built-in way of using it, if for no other reason than to be able to test if the feature even works. -- Jeff Hoffmann PropertyKey.com