Tom Lane wrote:
> My thought is that we could optimize away materialization in cases where
> we can tell it's not needed (no volatile functions and/or no multiple
> scans of the subquery). But not being able to do it means we've
> implemented the feature incorrectly.
>
>
>
I'm not sure how much work that would involve, but none of this means we
can't have the feature for 8.4, right? Just that there is more work to do.
cheers
andrew