Plpgsql get record value without colunm name ???

Started by Alban Médicialmost 24 years ago1 messagesgeneral
Jump to latest
#1Alban Médici
amedici@fr.netcentrex.net

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