From: | Allan Kamau <kamauallan(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | (Pl/SQL) Obtaining field names from record 'variable' |
Date: | 2007-12-11 12:07:16 |
Message-ID: | 248682.35322.qm@web53508.mail.re2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I am writing a PL/SQL script to process data from a high dimensionality table where this table has most of it's field names encapsulating data. I would like to automatically loop through the fields of a RECORD variable (returned from a cursor) obtaining the field name and the field value.
For example my table is listed below (briefly)
create table my_table
(
id int not null-- default nextval(('my_table_seq'::text)::regclass)
,some_explanation varchar(20) not null
,D30 varchar(100) null
,W32 varchar(100) null
,C33 varchar(100) null
,V7 varchar(100) null
,...
)
;
The field name W32 consists of 'W' which is data I need and '32' which is data I also need along with the actual record value contained in this field.
Allan.
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2007-12-11 13:42:31 | Re: Dangerous hint in the PostgreSQL manual |
Previous Message | Florian Weimer | 2007-12-11 10:26:05 | Re: Dangerous hint in the PostgreSQL manual |