variable name RESULT in PLPGSQL does not work (PG7.1)

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

Browse pgsql-general by date

  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