Avi Weinberg <a...@gilat.com> writes: > Is there a way to compute a column in a view only if it is referenced in the > query? I have a view's column that its value is computed by a function. If > in the query that column is not used at all, can Postgres "skip" computing it?
If the function is not volatile, and you're using a moderately recent PG version, I'd expect the planner to do that for you. regards, tom lane