Search Postgresql Archives

Re: How iterate records

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jan Poslusny wrote:
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...

You'll need to use another language. As you say, plpgsql isn't designed for this sort of thing, and it's not clear how you would handle different types as you iterated over row attributes.


Try pltcl or plperl (or python I'd have thought) - they're much more suited to this sort of thing.

PS - IMHO, formatting data into XML is a client-side task, middle-ware probably.
--
Richard Huxton
Archonet Ltd


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux