Re: BUG #9743: subquery on view is not pulling up.

kwalbrecht@cghtech.com writes:
> When I query a view which has calculated values, even if I don't select one
> of the calculated values, they are being calculated.

This example looks like the functions in question are marked volatile;
that prevents the view from being flattened, since doing so would
eliminate side-effects the user might be expecting to happen.  Assuming
yours are side-effect-free, mark them stable or immutable as appropriate.

http://www.postgresql.org/docs/9.2/static/xfunc-volatility.html

            regards, tom lane