Re: [SQL] pesky plpgsql

[Walter McGinnis]

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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])