Hi,
I'm looking for a way to build large xml documents based on a set of tables,
hence using recursive queries.
something like:
FOR rec1 IN ...
FOR rec2 IN ...
RETURN QUERY select '<foo>
FOR rec3 IN ...
RETURN QUERY select (XMLELEMENT (...))::text
END LOOP;
RETURN QUERY select '</foo>
END LOOP;
END LOOP;
but if I wrap this in a function, it seems that I won't get a result before
the whole document is prepared.
Is there any way to stream the result as it get produced ?
or does anybody knows of a good tutotial for a task like this ?
thanks and best regards,
Marc Mamin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
