X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C2DA6474E4F for ; Thu, 13 Feb 2003 12:02:24 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 8DE2E474E42 for ; Thu, 13 Feb 2003 12:02:22 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2838123; Thu, 13 Feb 2003 09:02:34 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Johnny Kristensen" , Subject: Re: SQL Functions vs PL/PgSQL Date: Thu, 13 Feb 2003 09:02:05 -0800 User-Agent: KMail/1.4.3 References: <000801c2d2e0$edd32420$dc9ac450@johnny> In-Reply-To: <000801c2d2e0$edd32420$dc9ac450@johnny> MIME-Version: 1.0 Message-Id: <200302130902.05987.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/291 X-Sequence-Number: 11689 Johnny, > Does postgres store execution plan's for user-defined SQL functions as the > PL/pgSQL interpreter does. And if so - will this only be prepared after an > initial call to the function? Can't seem to find this information in the > docs!? Thanks, Unless you know something I don't, I do not believe that PL/pgSQL stores=20 execution plans for functions. --=20 Josh Berkus Aglio Database Solutions San Francisco