>
> 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
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
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
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