On tis, 2010-05-25 at 12:05 -0400, Richard Wallace wrote:
> 1) When using cursor_to_xml in a plpgsql function, the FOUND variable does
> not seem to get set, so there is no way to exit a loop that is iterating over
> the cursor. Below is the function code; it loops indefinitely when it is run.
>
Hi all -
I'm currently wrestling with generating XML output from a table that has grown
to a size where simply using table_to_xml or query_to_xml is no longer feasible
due to the whole result set getting loaded into memory. I've been getting
familiar with cursors and the cursor_to_xml command a