Szymon Guz wrote: > 2010/3/19 Tom Lane <tgl@xxxxxxxxxxxxx> > > > Szymon Guz <mabewlun@xxxxxxxxx> writes: > > > You won't have to change the parameters in the function definition, > > instead > > > you can use the RENAME clause: > > > > > CREATE OR REPLACE FUNCTION add_user(user varchar(20), password > > varchar(20) ) > > > RETURNS VOID AS $$ > > > DECLARE > > > RENAME user TO x_user; > > > RENAME pa TO x_password; > > > BEGIN > > > > I wouldn't recommend relying on that, because RENAME has been removed in > > 9.0. I'm not convinced that it would have worked as desired in previous > > versions either. > > > > regards, tom lane > > > > Is alias also removed? > I've checked that and it works in 8.4 ALIAS is the recommended replacement for RENAME: http://developer.postgresql.org/pgdocs/postgres/release-9-0.html o Remove PL/pgSQL's RENAME declaration option (Tom) Instead, use ALIAS, which can now alias any variable, not just dollar sign variables, e.g. $1. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
