PLpgSQL FOR IN EXECUTE question

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема PLpgSQL FOR IN EXECUTE question
Дата
Msg-id 3DCA7A2E.6DD4CABE@rodos.fzk.de
обсуждение
Ответы Re: PLpgSQL FOR IN EXECUTE question
Re: PLpgSQL FOR IN EXECUTE question
Re: PLpgSQL FOR IN EXECUTE question
Список pgsql-sql
Consider the following PLpgSQL code fragment

FOR this_record IN
EXECUTE ''SELECT ''       || quote_ident($1)       || ''FROM ''       || quote_ident($2)
LOOP   list := list || '', '' || this_record.$1 ;
END LOOP;

As expected, accessing a field via this_record.$1
does not work.
Can it be done otherwise?

Regards, Christoph



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