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
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
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
That's got nothing to do with it being a
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?
you need to install contrib/btree_gist
btw, tsearch2 is much better than tsearch.
Check
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);
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
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?
Chris
---(end of broadcast)---
TIP 8: explain analyze is your friend
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
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?
Yeah. If you have a problem with that, it's grounds for a bug report.
Note though that GiST can't handle