Ron Johnson <ron.l.johnson@cox.net> writes:
> On 05/10/07 21:24, Tom Lane wrote:
>> "Leif B. Kristensen" <leif@solumslekt.org> writes:
>>> Would it be reasonable to suggest that later versions of PostgreSQL
>>> could examine if a function changes data, and quietly marks a function
>>> as 'stable' if it doesn't?
>>
>> My instinctive CS-major reply to that is "only if you've found a
>> solution to the halting problem". However, it's possible that we could
>> detect this case for a useful subset of real-world functions ... not
>> sure offhand what could be covered.
>
> If there are no INSERT, UPDATE or DELETE statements in the function?
And all functions called from inside the one being run as well
(recursive condition, of course)...
--
Jorge Godoy <jgodoy@gmail.com>
