Re: Views- Advantages and Disadvantages

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/10/07 21:24, Tom Lane wrote:
> "Leif B. Kristensen" <leif(at)solumslekt(dot)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?

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGQ9nCS9HxQb37XmcRAuxyAJ9Setk7j5/xg5jwvNi3o6RDceuGLACg1FDS
LptxOrJvoNVSjEATWIeFo+Y=
=5MT8
-----END PGP SIGNATURE-----