How iterate records - Mailing list pgsql-general

From Jan Poslusny
Subject How iterate records
Date
Msg-id 421B1567.8090108@gingerall.cz
Whole thread Raw
Responses Re: How iterate records  (Richard Huxton <dev@archonet.com>)
Re: How iterate records  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
List pgsql-general
Hi,
I have a problem of plpgsql usage. When I iterate through dynamic query, like this:

FOR my_/record/ IN EXECUTE /text_expression/ LOOP
    /statements/
END LOOP;

I am not able to construct expression, which can get value for each 'item' of my_record, something like my_record[3] or
get_item(my_record,3), without knowledge about real names of record pieces. I know that it is not the goal of this
language,but my goal is to implement some lite functions returning XML rather then something else... 

pajout



pgsql-general by date:

Previous
From: "FERREIRA William (COFRAMI)"
Date:
Subject: rows and array
Next
From: Richard Huxton
Date:
Subject: Re: rows and array