Re: missing... at end of sql expression - Mailing list pgsql-sql

From Tom Lane
Subject Re: missing... at end of sql expression
Date
Msg-id 1449.1101085413@sss.pgh.pa.us
Whole thread Raw
In response to missing... at end of sql expression  (Justine.Cleary@c1data.com)
List pgsql-sql
Justine.Cleary@c1data.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


pgsql-sql by date:

Previous
From: "Premsun Choltanwanich"
Date:
Subject: How to make lo_import and lo_export to use file on client local machine?
Next
From: Michael Fuhr
Date:
Subject: Re: missing... at end of sql expression