Re: Views- Advantages and Disadvantages - Mailing list pgsql-general

From Tom Lane
Subject Re: Views- Advantages and Disadvantages
Date
Msg-id 9921.1178850295@sss.pgh.pa.us
Whole thread Raw
In response to Re: Views- Advantages and Disadvantages  ("Leif B. Kristensen" <leif@solumslekt.org>)
Responses Re: Views- Advantages and Disadvantages
Re: Views- Advantages and Disadvantages
List pgsql-general
"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.

            regards, tom lane

pgsql-general by date:

Previous
From: Klint Gore
Date:
Subject: Re: Views- Advantages and Disadvantages
Next
From: novnov
Date:
Subject: Re: Installation fails on windows vista