From: | Mirko Zeibig <mirko(at)picard(dot)inka(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | variable name RESULT in PLPGSQL does not work (PG7.1) |
Date: | 2001-01-10 16:02:28 |
Message-ID: | 20010110170228.A5604@picard.inka.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello everybody,
I converted some existing plpgsql-scripts from 7.0.3 to 7.1 (CVS from
2001-01-09) and had problems with a variable RESULT in my script. E.g.:
drop function bla(integer);
create function bla(integer) returns integer as '
declare
RESULT integer;
begin
RESULT:=$1;
return RESULT;
end;'
language 'plpgsql';
will result in:
test=> SELECT bla(4);
NOTICE: plpgsql: ERROR during compile of bla near line 2
ERROR: parse error at or near "RESULT"
whereas bla will work if I rename RESULT to RESLT. I did not find any
documentation about a special variable-name, but a quick grep through the
*.c-files did show some results in src/backend/nodes, RESULT seems to be
part of executor-"plans".
Maybe this behaviour should be documented :-).
Best Regards
Mirko
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Weinberg | 2001-01-10 16:12:20 | Copying an index from one copy of a database to another |
Previous Message | Jeff Eckermann | 2001-01-10 15:47:42 | RE: converting .xls to delimited file |