Re: [GENERAL] GIST index on geometry+integer

2007-03-08 Thread Arnaud Lesauvage
Oleg Bartunov a écrit : Try install contrib/btree_gist Thanks a lot ! Regards -- Arnaud ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] GIST index on geometry+integer

2007-03-08 Thread Oleg Bartunov
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

[GENERAL] GIST index on geometry+integer

2007-03-08 Thread Arnaud Lesauvage
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