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