Re: Need help to dynamically access to colomns in function!

Поиск
Список
Период
Сортировка
От Ivan Pavlov
Тема Re: Need help to dynamically access to colomns in function!
Дата
Msg-id 795385b5-b7e0-4ec2-b0ae-5af31d89dd33@e6g2000vbe.googlegroups.com
обсуждение исходный текст
Ответ на Need help to dynamically access to colomns in function!  ("Иван Марков" <aesthete2005@gmail.com>)
Список pgsql-general
Please disregard my other message. I didn't get what you are trying to
do at first.
You can do this with dynamic SQL: Look at 38.5.4. Executing Dynamic
Commands (http://www.postgresql.org/docs/current/static/plpgsql-
statements.html).
I guess something like

EXECUTE 'SELECT tmprec.group' || i  INTO value

will work in a loop. Didn't try it though.

regards,
Ivan Pavlov


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

Предыдущее
От: "Gauthier, Dave"
Дата:
Сообщение: Re: Isolating a record column from a PL-Pgsql function call ?
Следующее
От: TJ O'Donnell
Дата:
Сообщение: Re: Lost password