pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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