Re: Views- Advantages and Disadvantages

Tom Lane wrote:
> Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> writes:
>> On 05/10/07 21:24, Tom Lane wrote:
>>> 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 no EXECUTE or PERFORM statements probably, or you'd have to
determine if the succeeding string might evaluate to INSERT, UPDATE or
DELETE.

And of course DDL statements would be out of the question too...

> Nor any function calls ... which leaves about nothing ...

Wouldn't that only be the case if those were volatile?

--
Alban Hertroys
alban(at)magproductions(dot)nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede

// Integrate Your World //