X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 92AC8925818 for ; Thu, 22 May 2003 12:17:15 -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 97681-06 for ; Thu, 22 May 2003 12:17:14 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id 00315925AA2 for ; Thu, 22 May 2003 11:15:47 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4MFFiU6019212; Thu, 22 May 2003 11:15:44 -0400 (EDT) To: Franco Bruno Borghesi Cc: pgsql-sql@postgresql.org Subject: Re: function prepared plan In-reply-to: <200305221204.11126.franco@akyasociados.com.ar> References: <200303211910.01785.franco@akyasociados.com.ar> <13729.1053571544@sss.pgh.pa.us> <200305221204.11126.franco@akyasociados.com.ar> Comments: In-reply-to Franco Bruno Borghesi message dated "Thu, 22 May 2003 12:04:11 -0300" Date: Thu, 22 May 2003 11:15:44 -0400 Message-ID: <19211.1053616544@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/418 X-Sequence-Number: 13583 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