Re: Composite GiST indexes?
От
Christopher Kings-Lynne
Тема
Re: Composite GiST indexes?
Дата
Msg-id
3FF9120F.1010805@familyhealth.com.au
Ответ на
Re: Composite GiST indexes? (Tom Lane)
Список
Дерево обсуждения
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 по дате отправления