Alternative way to access a field in a %ROWTYPE variable

Поиск
Список
Период
Сортировка
От Ismael ....
Тема Alternative way to access a field in a %ROWTYPE variable
Дата
Msg-id BLU103-W3DA52E8B58BB3C26F345DA37D0@phx.gbl
обсуждение исходный текст
Список pgsql-general
Hi,
Is there another way to access to the field in a variable of type record?

I need to store the name of a field in a variable and access
the field whose name matches the content of the variable.

Just as an example of what I want to do, the table or view "pg_user "
has at least the field usename, usesysid, valuntil

So I need to access the fields in a way similar to this
DECLARE
row pg_user%ROWTYPE;
field VARCHAR';

BEGIN
field = 'usename';
row.field = 'name';
field = 'usesysid';
row.field = 0;
field = 'valuntil':
row.field = 'who knows';


Is it possible to do something like that?
because that example doesn't work

I'm using plpgsql;

tanks in advance
_________________________________________________________________
Plug&Play te trae en exclusiva los mejores conciertos de la red
http://club.prodigymsn.com/

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Error 10061
Следующее
От: "EXT-Rothermel, Peter M"
Дата:
Сообщение: Declaring constants in SQL