Re: PL/pgSQL RENAME functionality in TODOs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/pgSQL RENAME functionality in TODOs
Date
Msg-id 9845.1170192857@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL RENAME functionality in TODOs  (imad <immaad@gmail.com>)
Responses Re: PL/pgSQL RENAME functionality in TODOs
List pgsql-hackers
imad <immaad@gmail.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


pgsql-hackers by date:

Previous
From: "Nikolay Samokhvalov"
Date:
Subject: Re: Modifying and solidifying contrib
Next
From: "Simon Riggs"
Date:
Subject: Improving NOT IN