From lgomez@itba.edu.ar Sun Mar 4 15:53:20 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5173C9FA3E9 for ; Sun, 4 Mar 2007 11:53:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 44219-10 for ; Sun, 4 Mar 2007 11:53:10 -0400 (AST) X-Greylist: delayed 00:32:25.683757 by SQLgrey-1.7.4 Received: from pucho.itba.edu.ar (pucho.itba.edu.ar [200.49.213.61]) by postgresql.org (Postfix) with ESMTP id BC6B39FB27A for ; Sun, 4 Mar 2007 11:53:16 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by pucho.itba.edu.ar (Postfix) with ESMTP id 0C83823D92 for ; Sun, 4 Mar 2007 12:20:45 -0300 (ART) X-Virus-Scanned: amavisd-new at itba.edu.ar Received: from pucho.itba.edu.ar ([127.0.0.1]) by localhost (pucho.itba.edu.ar [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 072xhAQ5zDQ0 for ; Sun, 4 Mar 2007 12:20:44 -0300 (ART) Received: from hammer (41-41-16-190.fibertel.com.ar [190.16.41.41]) by pucho.itba.edu.ar (Postfix) with ESMTP id 8F02323CAC for ; Sun, 4 Mar 2007 12:20:44 -0300 (ART) From: "Leticia" To: Subject: Multikey Index GISt Date: Sun, 4 Mar 2007 12:20:37 -0300 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0009_01C75E57.847B0950" X-Priority: 1 (Highest) X-MSMail-Priority: High X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: High Thread-Index: AcdecKl6XVKlEbAZSwqzmdNTvULywg== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.435 tagged_above=0 required=5 tests=BAYES_50, HTML_MESSAGE, X_PRIORITY_HIGH X-Spam-Level: X-Archive-Number: 200703/9 X-Sequence-Number: 6450 This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C75E57.847B0950 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0009_01C75E57.847B0950 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_0009_01C75E57.847B0950-- From tgl@sss.pgh.pa.us Sun Mar 4 18:40:08 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 203EB9FB33B for ; Sun, 4 Mar 2007 14:40:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 49063-04 for ; Sun, 4 Mar 2007 14:40:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id EEF5F9FB27E for ; Sun, 4 Mar 2007 14:40:02 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l24IdVwj022917; Sun, 4 Mar 2007 13:39:31 -0500 (EST) To: "Leticia" cc: pgsql-interfaces@postgresql.org Subject: Re: Multikey Index GISt In-reply-to: References: Comments: In-reply-to "Leticia" message dated "Sun, 04 Mar 2007 12:20:37 -0300" Date: Sun, 04 Mar 2007 13:39:31 -0500 Message-ID: <22916.1173033571@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.06 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/14 X-Sequence-Number: 6455 "Leticia" 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