From: | Alex Sandini <asandini(at)keyware(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | again, pgplsql and parameters question |
Date: | 2002-09-13 14:15:29 |
Message-ID: | 3D81F301.1090403@keyware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Soory for this retry, here it is
With pg 7.1.3,
I don't get parameters working in my pgplsql functions.
I.e.:
CREATE FUNCTION add_one (INTEGER) RETURNS INTEGER AS '
BEGIN
RETURN ($1 + 1);
END;
' LANGUAGE 'plpgsql';
Gives:
ERROR: Unable to identify left operator '+' for type 'int4'
You may need to add parentheses or an explicit cast
While the following one works just fine.
CREATE FUNCTION startweek() RETURNS DATE AS '
DECLARE
start date;
BEGIN
start:= to_date(''01-01-''||date_part(''year'', timestamp ''now''),''DD
MM YYYY'') + date_part(''week'', timestamp ''now'') * 7 - 8;
RETURN start;
END;
' LANGUAGE 'plpgsql';
ERROR: Unable to identify left operator '+' for type 'int4'
You may need to add parentheses or an explicit cast
Any idea?
Thanks,
Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-09-13 14:46:52 | Re: explain analyze |
Previous Message | Jim Buttafuoco | 2002-09-13 13:47:28 | Re: Query having issues... |