Re: [HACKERS] Multicolumn Indexing using R-Tree

2004-02-03 Thread Paul Ramsey
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 messa

Re: [HACKERS] Multicolumn Indexing using R-Tree

2004-02-03 Thread Teodor Sigaev
Try contrib/rtree_gist Marcio Caetano wrote: 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 c

[HACKERS] Multicolumn Indexing using R-Tree

2004-02-03 Thread Marcio Caetano
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 limitati