pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTriggers on SELECT
2+ messages / 2 participants
[nested] [flat]
* Triggers on SELECT
@ 2001-04-12 18:32 Lonnie Cumberland <lonnie_cumberland@yahoo.com>
2001-04-12 18:47 ` Re: Triggers on SELECT Joel Burton <jburton@scw.org>
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:32 Triggers on SELECT Lonnie Cumberland <lonnie_cumberland@yahoo.com>
@ 2001-04-12 18:47 ` Joel Burton <jburton@scw.org>
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