Column names as variables in plpgsql
От
Derrick Betts
Тема
Column names as variables in plpgsql
Дата
Msg-id
0eb901c69c95$17ccdd80$0202a8c0@main
Список
Дерево обсуждения
insert more than one rows "roy simkes" <roysimkes@hotmail.com>
Re: insert more than one rows "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: insert more than one rows "Andrej Ricnik-Bay" <andrej.groups@gmail.com>
Re: insert more than one rows "Garcia, Joshua" <Joshua.Garcia@xerox.com>
Is it possible to assign a column name to a variable and then use that
variable in a SELECT statement inside a function using plpgsql?
For example:
CREATE OR REPLACE FUNCTION function_name("varchar")
RETURNS varchar AS
$BODY$
DECLARE
column_name alias for $1;
status varchar;
BEGIN
SELECT column_name INTO status FROM contact_table WHERE id = 1;
RETURN status;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Thanks,
Derrick
В списке pgsql-novice по дате отправления
