Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAS4lIm34960 for ; Tue, 27 Nov 2001 23:47:18 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fAS4lKk00891; Tue, 27 Nov 2001 23:47:21 -0500 (EST) To: cnliou@eurosport.com cc: pgsql-sql@postgresql.org Subject: Re: PL/pgSQL examples NOT involving functions In-reply-to: <200111280034.09d3@lh00.opsion.fr> References: <200111280034.09d3@lh00.opsion.fr> Comments: In-reply-to message dated "Wed, 28 Nov 2001 00:34:09 +0000" Date: Tue, 27 Nov 2001 23:47:20 -0500 Message-ID: <888.1006922840@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/377 X-Sequence-Number: 5759 writes: > If I exit plpgsql and reenter, then "select test3()" > works again. So I guess "the first time" in > "The PL/pgSQL call handler parses the function's > source text and produces an internal binary > instruction tree the first time the function is > called." > might be referring to "for each client connection". Yup. I have tried to improve this documentation for 7.2. See the current version at http://candle.pha.pa.us/main/writings/pgsql/sgml/plpgsql.html and let me know if it still needs work. regards, tom lane