Szymon Guz wrote:
> 2010/3/19 Tom Lane <t...@sss.pgh.pa.us>
> 
> > Szymon Guz <mabew...@gmail.com> 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  <br...@momjian.us>        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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to