Re: Views- Advantages and Disadvantages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Views- Advantages and Disadvantages
Date: 2007-05-11 02:24:55
Message-ID: 9921.1178850295@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message novnov 2007-05-11 02:28:31 Re: Installation fails on windows vista
Previous Message Klint Gore 2007-05-11 02:03:47 Re: Views- Advantages and Disadvantages