On Mon, Mar 1, 2010 at 9:10 PM, Ray Madigan wrote:
>
> What I want to do is when I do a SELECT on the Catalog and deliver the
> result to the user, I want to check to see if the FooKey is in the users
> ToDo table and set the value of a column isToDo to true or false depending
> on if the FooKey e
@postgresql.org] On Behalf Of Ray Madigan
Sent: Monday, March 01, 2010 7:11 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] Trigger on select :-(
What I want is to have a trigger on select, but since I have searched
the archives I know that is not possible. I also read that view rules
is the tech
What I want is to have a trigger on select, but since I have searched the
archives I know that is not possible. I also read that view rules is the
technology is whats available. Having never used views before I can't seem
to get my mind to figure out what I need to do to solve my problem.
I have
On Tue, Aug 02, 2005 at 05:54:59PM -0700, Chris Travers wrote:
> >Hey, anyone know if it is possible to fire a trigger before a select?
> >I'm considering creating some tables which contain data summarized
> >from other tables as kind of a cache mechanism. The hope is I can
> >speed up some q
Kyle Bateman wrote:
Hey, anyone know if it is possible to fire a trigger before a select?
I'm considering creating some tables which contain data summarized
from other tables as kind of a cache mechanism. The hope is I can
speed up some queries that get executed a lot (and are kind of slow)
Hey, anyone know if it is possible to fire a trigger before a select?
I'm considering creating some tables which contain data summarized from
other tables as kind of a cache mechanism. The hope is I can speed up
some queries that get executed a lot (and are kind of slow) by
maintaining data (
