I am not really sure wether I MUST use it or not, but I think it is a
nice feature to be utilized.
What I want is a long running producing up to hundred of thousands
results which have to undergo a computationally expensive
postprocessing step which needs to be execeuted in parallel. By using
pipe
tschak wrote:
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).