Re: missing... at end of sql expression

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justine(dot)Cleary(at)c1data(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: missing... at end of sql expression
Date: 2004-11-22 01:03:33
Message-ID: 1449.1101085413@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Justine(dot)Cleary(at)c1data(dot)com writes:
> I am trying to learn pspgsql but I am not having a lot of luck.

> I have written a function but I keep getting the error missing... at end of
> sql expression. Can anyone help!

What it's really unhappy about is that you failed to declare the FOR
variable; this is causing it to assume that the FOR is the integer
variant (FOR i IN low .. high).

The error message is pretty confusing, I agree. I think 8.0 will
do better.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2004-11-22 01:09:18 Re: missing... at end of sql expression
Previous Message André Toscano 2004-11-21 23:07:48 Functions return a select in a table, which data type I must use? (Brazilian User)