Skip site navigation (1) Skip section navigation (2)

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

From: Decibel! <decibel(at)decibel(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 21:56:55
Message-ID: E6325E41-CB10-44AC-9962-F58D8EFE1E6B@decibel.org (view raw or flat)
Thread:
Lists: pgsql-general
On Sep 26, 2008, at 4:19 PM, Tom Lane wrote:
> Decibel! <decibel(at)decibel(dot)org> writes:
>> Does anyone have any ideas on a clean and reliable way to do this?
>
> Use a trigger.

The problem is that the rules are sitting on a view, not a real  
table. And the view has columns that don't exist in both tables, so I  
can't use a trigger on the tables to deal with everything.

This is 8.1; do later versions have the ability to put triggers on  
views?
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828


In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2008-09-26 22:17:51
Subject: Re: Is there any way to reliably influence WHERE predicate evaluation ordering?
Previous:From: Tom LaneDate: 2008-09-26 21:25:00
Subject: Re: Need Some Explanation of an EXPLAIN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group