X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0A589DA345 for ; Thu, 6 Oct 2005 05:19:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75845-08 for ; Thu, 6 Oct 2005 08:19:21 +0000 (GMT) Received: from zoom.spline.inf.fu-berlin.de (unknown [130.133.110.148]) by svr1.postgresql.org (Postfix) with ESMTP id D31C1D6E83 for ; Thu, 6 Oct 2005 05:19:21 -0300 (ADT) Received: by zoom.spline.inf.fu-berlin.de (Postfix, from userid 2091) id 4D6B654E00; Thu, 6 Oct 2005 10:19:20 +0200 (CEST) Date: Thu, 6 Oct 2005 10:19:19 +0200 From: Yann Michel To: "jan.aerts@bbsrc.ac.uk" Cc: pgsql-performance@postgresql.org Subject: Re: index on custom function; explain Message-ID: <20051006081919.GA17081@zoom.spline.inf.fu-berlin.de> References: <1128352451.312090.37640@g44g2000cwa.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1128352451.312090.37640@g44g2000cwa.googlegroups.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/121 X-Sequence-Number: 14889 Hi, On Mon, Oct 03, 2005 at 08:14:11AM -0700, jan.aerts@bbsrc.ac.uk wrote: > So my questions are: > * Does anyone have any idea how I can integrate a function that lists > all aliases for a given name into such a mapping query? what version are you using? TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Cheers, Yann