Postgres Pro
Downloads
Home   >   mailing lists

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

From lima_caetano@yahoo.com.br (Marcio Caetano)
Subject Multicolumn Indexing using R-Tree
Date
Msg-id 6e15fe24.0402030656.7a3bc91b@posting.google.com
Whole thread Raw
Responses Re: Multicolumn Indexing using R-Tree  (Teodor Sigaev <teodor@sigaev.ru>)
Re: Multicolumn Indexing using R-Tree  (Paul Ramsey <pramsey@refractions.net>)
List pgsql-hackers
Tree view 
Hello !

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: Tom Lane
Date:
Subject: Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4] "permissions problem" with pl/pgsql function )
Next
From: Rod Taylor
Date:
Subject: Re: Idea about better configuration options for sort