Re: PL/pgSQL loops?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Johnny Jørgensen" <pgsql(at)halfahead(dot)dk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PL/pgSQL loops?
Date: 2001-11-28 16:49:07
Message-ID: 2637.1006966147@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

=?ISO-8859-1?Q?=22Johnny_J=F8rgensen=22?= <pgsql(at)halfahead(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Carl van Tast 2001-11-28 17:52:49 Re: PL/pgSQL loops?
Previous Message wHarouny 2001-11-28 16:27:37 email address for questions