Re: missing... at end of sql expression

Re: missing... at end of sql expression

am 22.11.2004 02:03:33 von tgl

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)