Looping through fields

From: Enrique Filberto <hopeu(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Looping through fields
Date: 2002-10-17 08:56:12
Message-ID: 3dae7b2c_1@news.tiscalinet.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

I wonder if there is a possibility to not
only loop through record's with a FOR loop,
but also loop through the record itselfs.
Meaning something like that:

FOR record IN SELECT * FROM table LOOP

FOR each field IN record LOOP

return all field values

END LOOP

END LOOP

I fear I have to read the systems table to
get all field names and then read one field
after another from the record with the names
from the systems table?

Regards
elf

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-10-17 12:45:50 Re: PL/Perl and Perl 5.8
Previous Message Lee Kindness 2002-10-17 08:33:54 Re: COPY syntax