Re: Multikey Index GISt

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Multikey Index GISt
Дата
Msg-id 22916.1173033571@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Multikey Index GISt  ("Leticia" <lgomez@itba.edu.ar>)
Список pgsql-interfaces
"Leticia" <lgomez@itba.edu.ar> writes:
> If a use "create index anIndex on tablename using ( atr1   atr1_ops,  atr2
> atr2_ops,  atr3   atr3_ops) ", 

> I will obtain three separated invocation of "compress" function (one for
> each XXX_ops). I need to receive them in only one invocation.

You can't.  The fact that you want to means that you don't actually have
three independent operator classes there.  Perhaps what you really need
is a functional index on some function of the three columns?
        regards, tom lane


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Re: postgresql and XML
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Retrieving timestamp data