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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match