Re: PL/pgSQL loops?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: "Johnny Jrgensen" <pgsql(at)halfahead(dot)dk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: PL/pgSQL loops?
Date: 2001-11-29 23:13:05
Message-ID: 3774.1007075585@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ligia Pimentel 2001-11-29 23:22:22 An easy question about creating a primary key
Previous Message Bruce Momjian 2001-11-29 22:17:39 Re: CREATE RULE ON UPDATE/DELETE