Re: GIST index on geometry+integer

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83