Re: Is there any way to reliably influence WHERE predicate evaluation ordering?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Decibel! <decibel(at)decibel(dot)org>
Cc: General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is there any way to reliably influence WHERE predicate evaluation ordering?
Date: 2008-09-26 22:17:51
Message-ID: 29185.1222467471@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Decibel! <decibel(at)decibel(dot)org> writes:
> On Sep 26, 2008, at 4:19 PM, Tom Lane wrote:
>> Use a trigger.

> The problem is that the rules are sitting on a view,

Oh, I overlooked that bit :-(

> This is 8.1; do later versions have the ability to put triggers on
> views?

No, we still haven't figured out what an update or delete trigger would
act like.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2008-09-26 22:20:25 Rounding of floating point in text dumps?
Previous Message Decibel! 2008-09-26 21:56:55 Re: Is there any way to reliably influence WHERE predicate evaluation ordering?