Postgres Pro
Downloads
Home   >   mailing lists

GIST index on geometry+integer - Mailing list pgsql-general

From Arnaud Lesauvage
Subject GIST index on geometry+integer
Date
Msg-id 45EFC30A.7020108@laposte.net
Whole thread Raw
Responses Re: GIST index on geometry+integer  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "CAJ CAJ"
Date:
Subject: Real world performance improvements in 8,2
Next
From: Oleg Bartunov
Date:
Subject: Re: GIST index on geometry+integer