Re: Composite GiST indexes?

On Mon, 5 Jan 2004, Christopher Kings-Lynne wrote:

> >>Is it possible to make a composite GiST index?  I want to create an
> >>index on a txtidx and a timestamp column - is that at all possible?
>
> OK, this is what I'm trying (7.3.4):
>
> create index blah on forums_posts using gist(ftiidx, datetime);
>
> ERROR:  data type timestamp with time zone has no default operator class
> for access method "gist"
>          You must specify an operator class for the index or define a
>          default operator class for the data type
>
> I guess I can put an ops indicator in there, but I have no idea what to
> try using...

install contrib/btree_gist


>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
Regards,    Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83