imad <immaad(at)gmail(dot)com> writes:
> "Fix RENAME to work on variables other than OLD/NEW"
> I can rename just any variable declared in a PL block apart from
> OLD/NEW. Is the TODOs list out of sync or I am missing the point here?
Really? It looks pretty broken to me still:
regression=# create function foo() returns int as $$
regression$# declare
regression$# x int := 1;
regression$# rename x to y;
regression$# begin
regression$# return y;
regression$# end;$$ language plpgsql;
ERROR: syntax error at or near "x"
LINE 4: rename x to y;
^
See old discussion here:
http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php
regards, tom lane