Re: Composite GiST indexes?

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Re: Composite GiST indexes?
Дата
Msg-id
3FF9120F.1010805@familyhealth.com.au
Ответ на
Список
Дерево обсуждения
Composite GiST indexes? Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Composite GiST indexes? Tom Lane <tgl@sss.pgh.pa.us>
Re: Composite GiST indexes? Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Composite GiST indexes? Tom Lane <tgl@sss.pgh.pa.us>
Re: Composite GiST indexes? Oleg Bartunov <oleg@sai.msu.su>
Re: Composite GiST indexes? Oleg Bartunov <oleg@sai.msu.su>
>>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


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: Composite GiST indexes?
От: Tom Lane
Дата:
Сообщение: Re: Composite GiST indexes?
FAQ