From: Ferruccio Zamuner <nonsolosoft@diff.org>
To: pgsql-sql@postgresql.org
Subject: PL/SQL trouble
Date: Tue, 26 Nov 2002 03:56:35 -0500
Message-ID: <E18GbWF-0007oU-00@global.dnsprotect.com> (raw)
Hi,
I really don't understand following PostgreSQL 7.2.3 behaviour:
$ psql mydb
mydb=> CREATE FUNCTION MONDAY(timestamp) RETURNS DATE AS '
DECLARE
var1 date;
BEGIN
select into var1 to_date($1::date-(case when extract(DOW from
timestamp $1) = 0 then 6 else (extract(DOW from timestamp $1)-1) end));
RETURN var1;
END'
language 'plpgsql';
CREATE
mydb=> select MONDAY('now'::timestamp);
NOTICE: Error occurred while executing PL/pgSQL function MONDAY
NOTICE: line 4 at select into variables
ERROR: parser: parse error at or near "$2"
mydb=> \q
But I've not inserted any $2 there.
I've rewritten the same function in other ways but I've got the same error.
I thank you in advance for any hints.
Bye, \fer
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: nonsolosoft@diff.org
Subject: Re: PL/SQL trouble
In-Reply-To: <E18GbWF-0007oU-00@global.dnsprotect.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