Обсуждение: GIST index on geometry+integer

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

Try install contrib/btree_gist

On Thu, 8 Mar 2007, Arnaud Lesauvage wrote:

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

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Oleg Bartunov a écrit :
> Try install contrib/btree_gist

Thanks a lot !

Regards
--
Arnaud