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