Re: referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal
Дата
Msg-id 21864.1180561883@sss.pgh.pa.us
обсуждение исходный текст
Ответ на referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal  ("David Monarchi" <david.e.monarchi@gmail.com>)
Список pgsql-novice
"David Monarchi" <david.e.monarchi@gmail.com> writes:
> I'm trying to dynamically assign values to attributes in a record without
> know which attribute values I will actually receive.

You're wasting your time trying to do that in plpgsql --- quite aside
from syntactic difficulties, the language doesn't work well for this
because it's statically typed.  Use one of the other PL languages.
In plperl, for instance, a record looks like a hash and it's easy to
iterate through the keys etc.

            regards, tom lane

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

Предыдущее
От: "David Monarchi"
Дата:
Сообщение: referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal
Следующее
От: "Jasbinder Singh Bali"
Дата:
Сообщение: Retreving count of rows returned by a join query