Re: insert in function writen in pgplsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Szymon Guz <mabewlun(at)gmail(dot)com>
Cc: Julius Tuskenis <julius(at)nsoft(dot)lt>, pgsql-admin(at)postgresql(dot)org
Subject: Re: insert in function writen in pgplsql
Date: 2010-03-19 18:45:00
Message-ID: 3701.1269024300@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Szymon Guz <mabewlun(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Szymon Guz 2010-03-19 19:16:15 Re: insert in function writen in pgplsql
Previous Message Szymon Guz 2010-03-19 17:27:16 Re: insert in function writen in pgplsql