Re: PL/pgSQL examples NOT involving functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cnliou(at)eurosport(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PL/pgSQL examples NOT involving functions
Date: 2001-11-28 04:47:20
Message-ID: 888.1006922840@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<cnliou(at)eurosport(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Johnny Jørgensen 2001-11-28 12:25:52 PL/pgSQL loops?
Previous Message Saira Somani 2001-11-28 01:10:31 Re: How can I return more than one row of data from pl/pgsql