Re: [GENERAL] How iterate records

2005-02-22 Thread Pavel Stehule
> > 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. > -- Its not true. There is SQL/XML, but PostgreSQL don't support this. Where you can use it: fast ge

Re: [GENERAL] How iterate records

2005-02-22 Thread Pavel Stehule
Hello, use other languege. You need hash table, and hash are not implemented in PL/pgSQL. Some examples http://www.root.cz/clanky/plperl-postgresql-aplikacni-server/ but in czech language. Pavel On Tue, 22 Feb 2005, Jan Poslusny wrote: > Hi, > I have a problem of plpgsql usage. When I iter

Re: [GENERAL] How iterate records

2005-02-22 Thread Richard Huxton
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_recor

[GENERAL] How iterate records

2005-02-22 Thread Jan Poslusny
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