Re: R-Trees in PostgreSQL

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Viktor Rosenfeld <listuser36(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: R-Trees in PostgreSQL
Date: 2009-11-03 00:41:19
Message-ID: 1257208879.2649.15.camel@monkey-cat.sm.truviso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ramsey 2009-11-03 00:42:43 Re: R-Trees in PostgreSQL
Previous Message Viktor Rosenfeld 2009-11-02 23:25:04 R-Trees in PostgreSQL