On Tue, 2012-11-06 at 09:39 +0100, Dimitri Fontaine wrote:
> Jeff Davis <pgsql@j-davis.com> writes:
> > Take something as simple as generate_series: right now, it materializes
> > the entire thing if it's in the FROM clause, but it wouldn't need to if
> > it could use the foreign table mechanism.
>
> So, my understanding of your proposal is that a good way to implement
> streaming SRF would be on top of the internals of Foreign Data Wrappers?
Yes, I was talking about combining the mechanisms and combining the
capabilities of each mechanism. That would hopefully be a net decrease
in code, and offer the ability of FDWs to be strictly more powerful than
SRFs (though perhaps more challenging to develop).
Regards,Jeff Davis