plpgsql Question..

is it possible to access a feild in a RECORD type 
variable where the feild name is variable.

eg say r is a record having feild name , email , salary

r.name is 'foo'
r.email is 'bar@foo.com' 
r.salary is 1000

suppose  feild_name iterates via a FOR LOOP
through values (name , email , salary)

is it possible to access that feild in record r
inside the loop ?


Regds
mallah.


-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.