From: | "Ismael (dot)(dot)(dot)(dot)" <ismaelpsp(at)hotmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Alternative way to access a field in a %ROWTYPE variable |
Date: | 2008-07-30 19:54:53 |
Message-ID: | BLU103-W3DA52E8B58BB3C26F345DA37D0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | EXT-Rothermel, Peter M | 2008-07-30 20:16:35 | Declaring constants in SQL |
Previous Message | Alvaro Herrera | 2008-07-30 19:32:32 | Re: Error 10061 |