Received: from io.hypernet.com.py (io.hypernet.com.py [216.250.201.193])
	by postgresql.org (Postfix) with ESMTP id 58D7C474E4B
	for <pgsql-sql@postgresql.org>; Thu, 25 Apr 2002 00:38:05 -0400 (EDT)
Received: from there (ppp006.hypernet.com.py [216.250.201.217])
	by io.hypernet.com.py (8.9.3/8.9.3) with SMTP id AAA23606
	for <pgsql-sql@postgresql.org>; Thu, 25 Apr 2002 00:31:16 -0400
Message-Id: <200204250431.AAA23606@io.hypernet.com.py>
Content-Type: text/plain;
  charset="iso-8859-1"
From: Bruno Ricardo Sacco <bsacco@hypernet.com.py>
To: pgsql-sql@postgresql.org
Subject: Pl/pgSQL Question.
Date: Thu, 25 Apr 2002 00:34:48 -0400
X-Mailer: KMail [version 1.3.1]
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200204/303
X-Sequence-Number: 7567

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