Thread: Plpgsql get record value without colunm name ???

Plpgsql get record value without colunm name ???

From
Alban Médici
Date:
Hi,


I have an array passed in paramaters of a method :
arrayOfColunmName


I need to get value of record not like

LOOP ...
var=     record."columnName";
....
END LOOP



But like this :
LOOP
i =i +1;
var = record.arrayOfColunmName[i];
....
END LOOP.



Iit is possible or plpgsql is too limited to do that.

Or record[0][1] .... ????
I know record is like rowtype but I really blocked on this matter.




Helllllllllllllllppppppppppppppppp   !!!!


-- Alban Médici R&D Software Engineer tel: +33 (0)2 31 46 35 80 (+005) -------------------------------- http://www.netcentrex.net amedici@fr.netcentrex.net