From: Jan Wieck <JanWieck@Yahoo.com>
To: Walter McGinnis <walter@mars-hq.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: pesky plpgsql
Date: Thu, 03 Apr 2003 13:54:05 -0500
Message-ID: <3E8C834D.48B30572@Yahoo.com> (raw)
References: <F122429B-64C3-11D7-AEDC-00306571D2C4@mars-hq.com>
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 #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: JanWieck@Yahoo.com, walter@mars-hq.com
Subject: Re: pesky plpgsql
In-Reply-To: <3E8C834D.48B30572@Yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox