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@Yahoo.com #