pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Allan Kamau <kamauallan@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: (Pl/SQL) Obtaining field names from record 'variable'
Date: Tue, 11 Dec 2007 04:07:16 -0800 (PST)
Message-ID: <248682.35322.qm@web53508.mail.re2.yahoo.com> (raw)
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
view thread (3+ messages) latest in thread
Message-ID: <248682.35322.qm@web53508.mail.re2.yahoo.com> Permalink: ../248682.35322.qm@web53508.mail.re2.yahoo.com/ Also on: postgresql.org/message-id/248682.35322.qm@web53508.mail.re2.yahoo.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-admin@postgresql.org Cc: kamauallan@yahoo.com Subject: Re: (Pl/SQL) Obtaining field names from record 'variable' In-Reply-To: <248682.35322.qm@web53508.mail.re2.yahoo.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox