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
