Re: Views- Advantages and Disadvantages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Views- Advantages and Disadvantages
Date: 2007-05-11 03:21:30
Message-ID: 10590.1178853690@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

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

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Godoy 2007-05-11 03:32:39 Re: Views- Advantages and Disadvantages
Previous Message Ron Johnson 2007-05-11 02:58:01 Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)