X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 4214B925B70 for ; Thu, 22 May 2003 12:25:04 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 01111-02 for ; Thu, 22 May 2003 12:24:30 -0400 (EDT) Received: from lucifer.akyasociados.com.ar (unknown [200.69.203.237]) by developer.postgresql.org (Postfix) with ESMTP id DAC929256ED for ; Thu, 22 May 2003 11:20:32 -0400 (EDT) Received: from demos.oficina (demos.oficina [192.168.1.199]) (authenticated bits=0) by lucifer.akyasociados.com.ar (8.12.9/8.12.9) with ESMTP id h4MFMrhW013146; Thu, 22 May 2003 12:22:54 -0300 (ART) (envelope-from franco@akyasociados.com.ar) From: Franco Bruno Borghesi Organization: AK y Asociados S.R.L. To: Tom Lane Subject: Re: function prepared plan Date: Thu, 22 May 2003 12:26:58 -0300 User-Agent: KMail/1.5.1 Cc: pgsql-sql@postgresql.org References: <200303211910.01785.franco@akyasociados.com.ar> <200305221204.11126.franco@akyasociados.com.ar> <19211.1053616544@sss.pgh.pa.us> In-Reply-To: <19211.1053616544@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305221226.59197.franco@akyasociados.com.ar> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/419 X-Sequence-Number: 13584 That's great! I'll cast everything then. Thanks Tom. On Thursday 22 May 2003 12:15, Tom Lane wrote: > Franco Bruno Borghesi writes: > > Ok Tom, I'll try casting in the testSQL function like you said... but let > > me ask you another thing: what is plpgsql exactily caching? > > The plan for the "CAST(foo AS TEXT)" expression. Under the hood that's > a SELECT CAST($1 AS TEXT), and it has a plan. > > regards, tom lane