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: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend