Re: PL/pgSQL loops? - Mailing list pgsql-sql

From Tom Lane
Subject Re: PL/pgSQL loops?
Date
Msg-id 2637.1006966147@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL loops?  ("Johnny Jørgensen" <pgsql@halfahead.dk>)
Responses Re: PL/pgSQL loops?  (Roberto Mello <rmello@cc.usu.edu>)
Re: PL/pgSQL loops?  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
"Johnny Jørgensen" <pgsql@halfahead.dk> writes:
> I have a problem with the following function:
> [snip]
> - counting my way through the thing, i gather that it's the last END LOOP; =
> that causes problems - but it's in every way similar to the inner loop?

I can't see anything wrong with it either.  What PG version are you
running?


> does compile mean "This is the first run, so I compile the thing" (to make =
> it possible to create interdependent functions), or does it mean "The funct=
> ion is called, so I compile it, in the current setting, and execute it"?

I've tried to clarify this in the docs for 7.2; see
http://candle.pha.pa.us/main/writings/pgsql/sgml/plpgsql.html#PLPGSQL-OVERVIEW
        regards, tom lane


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: PL/pgSQL loops?
Next
From: Carl van Tast
Date:
Subject: Re: PL/pgSQL loops?