Re: Suppressing unused subquery output columns

On 6/5/14, 9:54 PM, Tom Lane wrote:
> Rod Taylor <rod(dot)taylor(at)gmail(dot)com> writes:
>> On Thu, Jun 5, 2014 at 10:27 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> I'm not entirely convinced that it's worth the extra planning cycles,
>>> though. Given the small number of complaints to date, it might not
>>> be worth doing this. Thoughts?
>
>> Would this avoid execution of expensive functions in views when their
>> output is discarded?
>
> Yes, as long as they're not marked volatile and don't return sets.

That would certainly make it useful for us.
--
Jim C. Nasby, Data Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net