Re: insert in function writen in pgplsql

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: insert in function writen in pgplsql
Дата
Msg-id 3701.1269024300@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: insert in function writen in pgplsql  (Szymon Guz <mabewlun@gmail.com>)
Ответы Re: insert in function writen in pgplsql  (Szymon Guz <mabewlun@gmail.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Szymon Guz
Дата:
Сообщение: Re: insert in function writen in pgplsql
Следующее
От: Szymon Guz
Дата:
Сообщение: Re: insert in function writen in pgplsql