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 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
