Skip site navigation (1) Skip section navigation (2)

Re: Multikey Index GISt

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Leticia" <lgomez(at)itba(dot)edu(dot)ar>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Multikey Index GISt
Date: 2007-03-04 18:39:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
"Leticia" <lgomez(at)itba(dot)edu(dot)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

In response to

pgsql-interfaces by date

Next:From: Michael FuhrDate: 2007-03-04 19:17:18
Subject: Re: Retrieving timestamp data
Previous:From: Nikolay SamokhvalovDate: 2007-03-04 18:31:41
Subject: Re: postgresql and XML

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group