Re: pesky plpgsql

Thanks for your help.  I'm going to use this bit of functionality once 
or twice, so I went ahead and worked around it in an inelegant, but 
effective manner.

Oh well.

Walter

On Tuesday, April 1, 2003, at 10:03  PM, Tom Lane wrote:

> Walter McGinnis <pg@mars-hq.com> writes:
>> When I call the function I get the following error:
>> devpps=# select update_cat_keys();
>> NOTICE:  plpgsql: ERROR during compile of update_cat_keys near line 2
>> ERROR:  parse error at or near ";"
>> The select in the loop runs fine in psql.  So I'm stumped...
>
> Hmm, it looks fine to me too.  What PG version is this?  Could you
> provide the context (table creation commands, etc) so someone else
> could try to run the function?
>
>             regards, tom lane
>
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly