Re: RTREE on points

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Hoffmann <jeff(at)propertykey(dot)com>
Cc: Julian Scarfe <julian(at)avbrief(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: RTREE on points
Date: 2001-04-16 23:49:06
Message-ID: 19849.987464946@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jeff Hoffmann <jeff(at)propertykey(dot)com> writes:
> yes, it does seem like a little more work, but there doesn't seem to be
> a lot of usage of the geometric functions by the developers to look at
> missing features -- they're mostly just reactive to problems.

Jeff's correct, none of the core developers have much time to spend on
adding features to the geometric datatypes. If someone else wants to
step up to the plate, though, contributions are welcome ;-)

The procedure for adding a new index opclass is somewhat documented for
btree opclasses. To add an rtree opclass you'd be adding a different
set of operators and support functions, which set isn't documented
anywhere that I know of; you'd have to look at the existing examples
to figure out what is needed.

BTW, you should also look at the GIST stuff and figure out whether
it might not be better to develop a GIST opclass instead of rtree.
In the long run I suspect GIST will be better supported than rtree,
since it's more general.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Anand Raman 2001-04-17 06:34:14 Re: Cursors in plpgsql
Previous Message Bernardo de Barros Franco 2001-04-16 22:30:42 Re: Using Random Sequence as Key