Re: Suppressing unused subquery output columns

On 6/5/14, 9:54 PM, Tom Lane wrote:
> Rod Taylor <rod.taylor@gmail.com> writes:
>> On Thu, Jun 5, 2014 at 10:27 PM, Tom Lane <tgl@sss.pgh.pa.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@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net