I was reading through the docs today, and came across a paragraph that indicated when plpgsql queries are executed on the server, the results are all written to memory(or disk if necessary), and not streamed as available. I can't find the doc page which said it, but does anyone know if this applies to regular SQL as well, or is it just plpgsql specific. If it applies to either or both, are there any current plans to not have PG not behave in this manner, and stream the results of a query as they become available?
Thanks, Steve ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])