On 27.08.2007, at 18:07, Tom Lane wrote:
Kristo Kaiv <[EMAIL PROTECTED]> writes:
From http://www.postgresql.org/docs/current/static/plpgsql-
declarations.html#PLPGSQL-DECLARATION-RENAMING-VARS
Note: RENAME appears to be broken as of PostgreSQL 7.3. Fixing this
is of low priority, since ALIAS covers most of the practical uses of
RENAME.
Seems to work though. Could somebody please confirm/reject that this
has been fixed?
It "works" only for very small values of "works". See the links in
the TODO item for it.
regards, tom lane
Tom, the TODO item says:
Server-Side Languages
PL/pgSQL
Fix RENAME to work on variables other than OLD/NEW
but it seems to already work. I have tested it on 8.2 and have not
noticed any problems.
orderdb_test=# \df+ test
List of functions
-[ RECORD 1 ]-------+--------------------------
Schema | public
Name | test
Result data type | text
Argument data types | i_a text, OUT asi text
Owner | kristok
Language | plpgsql
Source code |
: DECLARE
: -- o_asi ALIAS FOR $2;
: RENAME asi TO o_asi;
: BEGIN
: select 32 into o_asi;
: return;
: END;
:
Description |
orderdb_test=# select * from test(123);
asi
-----
32
(1 row)
Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)
