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

From Tom Lane
Subject Re: PL/pgSQL loops?
Date
Msg-id 3774.1007075585@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/pgSQL loops?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PL/pgSQL loops?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
I said:
> I would've expected it to count nested parentheses, at least.

Okay, it does that now, and I found that I could tighten the error
checking to give a sooner/more useful error.  Now, if you get caught
by the integer-FOR-vs-FOR-over-rows problem, you'll probably get

ERROR:  missing .. at end of SQL expression

which at least gives you some clue that the problem has something to
do with the "FOR x IN foo .. bar" syntax.
        regards, tom lane


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: CREATE RULE ON UPDATE/DELETE
Next
From: "Peter T. Brown"
Date:
Subject: contracting tables