"Donald Fraser" <[EMAIL PROTECTED]> writes: > Is the returned value of a function defined as IMMUTABLE cached = > globally?
No, in fact it isn't cached at all. IMMUTABLE tells the planner that it's OK to fold a function call with constant inputs to a constant result value at plan time. Nothing more. 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