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

From Stephan Szabo
Subject Re: PL/pgSQL loops?
Date
Msg-id 20011130012817.T52306-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: PL/pgSQL loops?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Thu, 29 Nov 2001, Tom Lane wrote:

> 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.

Definately better, and it probably gives a more meaningful line number
too.




pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: Fixing faulty dates - select on day part of a date field
Next
From: MindTerm
Date:
Subject: Any available solution to port CONNECT BY of oracle to postgresql