Thread: Triggers on SELECT

Hello All,

I have been reading on the uses of the Triggers from within the PL/pgSQL
language and have seen that you can set up triggers for such things as UPDATE,
and INSERT.

I was just wondering why there was no trigger mechanicism for the SELECT
statement?

I could find some possible uses for this type of trigger as well.

Cheers,
Lonnie


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

On Thu, 12 Apr 2001, Lonnie Cumberland wrote:

> Hello All,
> 
> I have been reading on the uses of the Triggers from within the PL/pgSQL
> language and have seen that you can set up triggers for such things as UPDATE,
> and INSERT.
> 
> I was just wondering why there was no trigger mechanicism for the SELECT
> statement?

You could use a RULE instead -- you might be able to get what you want
this way.

-- 
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington