Re: [PERFORM] Stable function optimisation

2007-08-15 Thread Philipp Specht
Hi Tom, Thank you very much for your explanation. On 13.08.2007, at 23:01, Tom Lane wrote: Philipp Specht <[EMAIL PROTECTED]> writes: The biggest question here is: Why is the runtime of the query with the stable function not near the runtime of the immutable function? Stable functions don't

Re: [PERFORM] Stable function optimisation

2007-08-13 Thread Tom Lane
Philipp Specht <[EMAIL PROTECTED]> writes: > The biggest question here is: Why is the runtime of the query with > the stable function not near the runtime of the immutable function? Stable functions don't get folded to constants. > It's definitely one query and the manual states that a stable