Re: Suppressing unused subquery output columns - Mailing list pgsql-hackers

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.
        regards, tom lane