Re: Multicolumn Indexing using R-Tree - Mailing list pgsql-hackers

From Paul Ramsey
Subject Re: Multicolumn Indexing using R-Tree
Date
Msg-id 71121FA0-5682-11D8-B42D-000393D33C2E@refractions.net
Whole thread Raw
In response to Multicolumn Indexing using R-Tree  (lima_caetano@yahoo.com.br (Marcio Caetano))
List pgsql-hackers
Try using GiST rtree (examples in contrib), GiST supports multi-key
indexes.

On Tuesday, February 3, 2004, at 06:56 AM, Marcio Caetano wrote:

> I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that
> uses more than one column in a table.
>
> When I run the instruction it appears this message bellow:
>
> DefineIndex: access method "rtree" does not support multi-column
> indexes
>
> How can I solve this problem ?
> Is it a limitation of PostgreSQL or the R-Tree concept  ?
>
> Thank you in advance.
>
> Márcio Caetano


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Multicolumn Indexing using R-Tree
Next
From: Tom Lane
Date:
Subject: Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4] "permissions problem" with pl/pgsql function )