GIST index on geometry+integer

From: Arnaud Lesauvage <arnaud(dot)lesauvage(at)laposte(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: GIST index on geometry+integer
Date: 2007-03-08 08:02:18
Message-ID: 45EFC30A.7020108@laposte.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list !

I would like to test clustering on a multicolumn GIST index.
The first column is a PostGIS-geometry field, the second column is a smallint field.
When I try to create the index, I have an error about GIST not being available for smallint datatype.
How can I create this operator class ?

Thanks for your help !

Regards
--
Arnaud

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2007-03-08 09:30:21 Re: GIST index on geometry+integer
Previous Message CAJ CAJ 2007-03-08 08:00:12 Real world performance improvements in 8,2