From: Tom Lane <tgl@sss.pgh.pa.us>
To: Leticia <lgomez@itba.edu.ar>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Multikey Index GISt
Date: Sun, 04 Mar 2007 13:39:31 -0500
Message-ID: <22916.1173033571@sss.pgh.pa.us> (raw)
In-Reply-To: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAinigLB1zOkWncFD5xMZU5sKAAAAQAAAA5HVgnVESk0yrQs0K5l0+UAEAAAAA@itba.edu.ar>
References: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAinigLB1zOkWncFD5xMZU5sKAAAAQAAAA5HVgnVESk0yrQs0K5l0+UAEAAAAA@itba.edu.ar>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, lgomez@itba.edu.ar
Subject: Re: Multikey Index GISt
In-Reply-To: <22916.1173033571@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox