Re: Multikey Index GISt - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Multikey Index GISt
Date
Msg-id 22916.1173033571@sss.pgh.pa.us
Whole thread Raw
In response to Multikey Index GISt  ("Leticia" <lgomez@itba.edu.ar>)
List 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 by date:

Previous
From: "Nikolay Samokhvalov"
Date:
Subject: Re: postgresql and XML
Next
From: Michael Fuhr
Date:
Subject: Re: Retrieving timestamp data