Pl/pgSQL Question.

Im traing to make a pl/pgsql function that display records of a given table.
I pass the name of the table has an argument for the function.

Using the,
FOR myRec IN SELECT xxxxxxxxxxx LOOP

do some of the work, but I still need to know the names of the fields.

for example: myRec.name

there is a way to do same thing like :

myRec[0]

to reference fields in the record ?

I can retriebe the names of the table fields from then system tables, but
that din't help me.

Anyome knows how ?

Sorry for me english.....

-------------------------------------------------------------------------------------------------------------------------------
Bruno Ricardo Sacco
IT Manager
HyperNET ISP