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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
