Set Returning Function (Pipelining) - Mailing list pgsql-general

From tschak
Subject Set Returning Function (Pipelining)
Date
Msg-id 1132677859.476440.103770@o13g2000cwo.googlegroups.com
Whole thread Raw
Responses Re: Set Returning Function (Pipelining)  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Hi everyone,

I have a question on set returning functions. In one of the TechDocs on
the postgres website it says:
"Currently SRF returning PL/pgSQL functions must generate the entire
set before the result is returned"

It also says that this might be changed in future releases (later than
7.3).
My question is now wether the result is returned linewise in an newer
version and if yes, wether a program using the
S(erver)P(rogramming)I(interface) can utilize this functionality in
order get a better distribution of the workload?

Thx for your help,

tschak


pgsql-general by date:

Previous
From: Patrick Hatcher
Date:
Subject: Slow pgdump
Next
From: Joe Conway
Date:
Subject: Re: Set Returning Function (Pipelining)