From: | Bruno Ricardo Sacco <bsacco(at)hypernet(dot)com(dot)py> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Pl/pgSQL Question. |
Date: | 2002-04-25 04:44:59 |
Message-ID: | 200204250441.AAA23640@io.hypernet.com.py |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Morgan | 2002-04-25 05:44:15 | SELECT in a function != SELECT ? |
Previous Message | Bruno Ricardo Sacco | 2002-04-25 04:34:48 | Pl/pgSQL Question. |