Multicolumn Indexing using R-Tree

From: lima_caetano(at)yahoo(dot)com(dot)br (Marcio Caetano)
To: pgsql-general(at)postgresql(dot)org
Subject: Multicolumn Indexing using R-Tree
Date: 2004-02-03 14:52:11
Message-ID: 6e15fe24.0402030652.ca9c1fa@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Marcio Caetano 2004-02-03 15:04:05 Specifying a index
Previous Message David Garamond 2004-02-03 14:52:00 large crontab database design