Re: PL/pgSQL examples NOT involving functions - Mailing list pgsql-sql

From Tom Lane
Subject Re: PL/pgSQL examples NOT involving functions
Date
Msg-id 888.1006922840@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/pgSQL examples NOT involving functions  (<cnliou@eurosport.com>)
List pgsql-sql
<cnliou@eurosport.com> 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


pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: hu.po
Next
From: "Saira Somani"
Date:
Subject: Re: How can I return more than one row of data from pl/pgsql