Re: pesky plpgsql

Walter McGinnis wrote:
>
> Guess I'm an April Fool. When I define the following psql returns
> "CREATE":
> [...]
> 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...
>
> I'm pretty ignorant about plpgsql, I'm used to pl/sql.

What version of PostgreSQL and did you by any chance use a DOS editor
(or anything that creates CRLF end of lines for that matter)? Older
versions of PL/pgSQL didn't like that.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #