Column names as variables in plpgsql

Поиск
Список
Период
Сортировка
От Derrick Betts
Тема Column names as variables in plpgsql
Дата
Msg-id 0eb901c69c95$17ccdd80$0202a8c0@main
обсуждение исходный текст
Ответ на Re: insert more than one rows  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Ответы Re: Column names as variables in plpgsql
Список pgsql-novice
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 по дате отправления: