Plpgsql get record value without colunm name ???

From: Alban Médici <amedici(at)fr(dot)netcentrex(dot)net>
To: postgre general <pgsql-general(at)postgresql(dot)org>
Subject: Plpgsql get record value without colunm name ???
Date: 2002-04-24 13:49:18
Message-ID: 3CC6B7DE.2090106@fr.netcentrex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)fr(dot)netcentrex(dot)net

Browse pgsql-general by date

  From Date Subject
Next Message ARP 2002-04-24 13:56:16 Re: Connections per second?
Previous Message ARP 2002-04-24 13:47:16 Re: Bug or syntax error in my update query with a FROM statement ?