From: | George Essig <george_essig(at)yahoo(dot)com> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Composite GiST indexes? |
Date: | 2004-01-05 15:41:12 |
Message-ID: | 20040105154112.12785.qmail@web80208.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>>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...
>
> Chris
Install contrib/btree_gist so you can include the timestamp field in a gist index. Teodor Sigaev
suggested this on the openfts mailing list at:
http://sourceforge.net/mailarchive/message.php?msg_id=5349399
The btree_gist readme file says it supports the int2, int8, float4, float8, and timestamp data
types.
George Essig
From | Date | Subject | |
---|---|---|---|
Next Message | Alex J. Avriette | 2004-01-05 15:45:34 | Re: psql \d option list overloaded |
Previous Message | Oleg Bartunov | 2004-01-05 14:49:04 | Announce: Search PostgreSQL related resources |