Re: PL/pgSQL loops?

"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