Postgres Pro
Downloads
Home   >   mailing lists

Re: R-Trees in PostgreSQL - Mailing list pgsql-general

From Jeff Davis
Subject Re: R-Trees in PostgreSQL
Date
Msg-id 1257208879.2649.15.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to R-Trees in PostgreSQL  (Viktor Rosenfeld <listuser36@googlemail.com>)
Responses Re: R-Trees in PostgreSQL  (Paul Ramsey <pramsey@cleverelephant.ca>)
Re: R-Trees in PostgreSQL  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Tree view 
On Tue, 2009-11-03 at 00:25 +0100, Viktor Rosenfeld wrote:
> I'd like to know what kind of functions I have to implement for a R-Tree
> index on numeric columns,

NUMERIC is scalar, so an R-Tree doesn't make much sense. You can install
btree_gist (a contrib module) to be able to use numeric columns as part
of a GiST index.

If you have more complex spatial data, you should look into PostGIS.

Regards,
    Jeff Davis

pgsql-general by date:

Previous
From: Viktor Rosenfeld
Date:
Subject: R-Trees in PostgreSQL
Next
From: Scott Marlowe
Date:
Subject: Re: Help with postgresql memory issue