pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Multikey Index GISt
2+ messages / 2 participants
[nested] [flat]

* Multikey Index GISt
@ 2007-03-04 15:20 Leticia <lgomez@itba.edu.ar>
  2007-03-04 18:39 ` Re: Multikey Index GISt Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Leticia @ 2007-03-04 15:20 UTC (permalink / raw)
  To: pgsql-interfaces

I need to implement a new GisT index that use multikey (i.e. tree columns).

I need to storage in the entry index the three transformed columns
alltogether.

 

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. How can I do
it using GIsT?

 

I am using PostgreSQL8.2.3. How does it work the multikey GIsT announced in
the latest version of PosgreSQL?

 

Thanks a lot,

Leticia

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Multikey Index GISt
  2007-03-04 15:20 Multikey Index GISt Leticia <lgomez@itba.edu.ar>
@ 2007-03-04 18:39 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2007-03-04 18:39 UTC (permalink / raw)
  To: Leticia <lgomez@itba.edu.ar>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2007-03-04 18:39 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-04 15:20 Multikey Index GISt Leticia <lgomez@itba.edu.ar>
2007-03-04 18:39 ` Tom Lane <tgl@sss.pgh.pa.us>

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