Dean Rasheed <dean_rasheed@hotmail.com> writes: > My reason for asking is that some languages maintain a dependency tree > of functions, and so could in theory do something clever with > dependent functions - such as distinguishing between *declared* and > *derived* volatility. That might be possible in a system that only supports statically analyzable functions, but Postgres is not such a system. Consider EXECUTE in plpgsql, or anything at all in plperl or pltcl. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match