Re: [GENERAL] Set Returning Function (Pipelining)

2005-11-23 Thread tschak
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

Re: [GENERAL] Set Returning Function (Pipelining)

2005-11-22 Thread Joe Conway
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).