R-Trees in PostgreSQL

From: Viktor Rosenfeld <listuser36(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: R-Trees in PostgreSQL
Date: 2009-11-02 23:25:04
Message-ID: 20091102232504.GA35438@stan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'd like to create an R-Tree index on two numeric columns. As far as I
know, PostgreSQL supports R-Trees via the GiST index class for some
spatial types (box and the like). When I create a GiST index on two
numeric columns, I get the error message:

ERROR: data type numeric has no default operator class for access
method "gist"
HINT: You must specify an operator class for the index or define a
default operator class for the data type.

I'd like to know what kind of functions I have to implement for a R-Tree
index on numeric columns, particularly if that can be done in PL/PGSQL
or if I have to fall back to C.

Or maybe there already exists a solution? From web searches I gather
that PostgreSQL at one time supported R-Trees natively, but that it was
dropped in favor of GiST. I couldn't find anything in the contrib
directory.

Thanks,
Viktor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2009-11-03 00:41:19 Re: R-Trees in PostgreSQL
Previous Message Brooks Lyrette 2009-11-02 22:56:39 Re: Help with postgresql memory issue