pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Triggers on SELECT
2+ messages / 2 participants
[nested] [flat]

* Triggers on SELECT
@ 2001-04-12 18:32  Lonnie Cumberland <lonnie_cumberland@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Lonnie Cumberland @ 2001-04-12 18:32 UTC (permalink / raw)
  To: pgsql-sql

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Triggers on SELECT
@ 2001-04-12 18:47  Joel Burton <jburton@scw.org>
  parent: Lonnie Cumberland <lonnie_cumberland@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Joel Burton @ 2001-04-12 18:47 UTC (permalink / raw)
  To: Lonnie Cumberland <lonnie_cumberland@yahoo.com>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-04-12 18:47 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-12 18:32 Triggers on SELECT Lonnie Cumberland <lonnie_cumberland@yahoo.com>
2001-04-12 18:47 ` Joel Burton <jburton@scw.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox