X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 48A2C4759BD for ; Thu, 13 Feb 2003 04:49:46 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 937CF4759AF for ; Thu, 13 Feb 2003 04:49:45 -0500 (EST) Received: from klaster.net (ph218.krakow.cvx.ppp.tpnet.pl [217.99.208.218]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id D20C92B884; Thu, 13 Feb 2003 10:41:39 +0100 (CET) Message-ID: <3E4B639F.1090703@klaster.net> Date: Thu, 13 Feb 2003 10:21:35 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Johnny Kristensen Cc: pgsql-sql@postgresql.org Subject: Re: SQL Functions vs PL/PgSQL References: <000801c2d2e0$edd32420$dc9ac450@johnny> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/280 X-Sequence-Number: 11678 Johnny Kristensen wrote: > Hi! > 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, > Johnny Kristensen You need Postgresql 7.3 to do this. Check sql function "PREPARE". Regards, Tomasz Myrta