From: Bruce Momjian <bruce@momjian.us>
To: Szymon Guz <mabewlun@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Julius Tuskenis <julius@nsoft.lt>
Cc: pgsql-admin@postgresql.org
Subject: Re: insert in function writen in pgplsql
Date: Mon, 22 Mar 2010 18:47:34 -0400 (EDT)
Message-ID: <201003222247.o2MMlYI17160@momjian.us> (raw)
In-Reply-To: <e4edc9361003191216o34904967o7865a1dab35a4d6c@mail.gmail.com>
Szymon Guz wrote:
> 2010/3/19 Tom Lane <tgl@sss.pgh.pa.us>
>
> > Szymon Guz <mabewlun@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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, mabewlun@gmail.com, tgl@sss.pgh.pa.us, julius@nsoft.lt
Subject: Re: insert in function writen in pgplsql
In-Reply-To: <201003222247.o2MMlYI17160@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox