pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedon select rule
4+ messages / 3 participants
[nested] [flat]
* on select rule
@ 2006-04-13 15:46 Sergey Levchenko <sector119@gmail.com>
2006-04-13 21:40 ` Re: on select rule A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 1 reply; 4+ messages in thread
From: Sergey Levchenko @ 2006-04-13 15:46 UTC (permalink / raw)
To: pgsql-sql
Hi
If I can not do insert/update action with on select rule, how can I
execute some procedure or any sql statement on select event?
WBR
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: on select rule
2006-04-13 15:46 on select rule Sergey Levchenko <sector119@gmail.com>
@ 2006-04-13 21:40 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-04-14 07:00 ` Re: on select rule Sergey Levchenko <sector119@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: A. Kretschmer @ 2006-04-13 21:40 UTC (permalink / raw)
To: pgsql-sql
am 13.04.2006, um 18:46:02 +0300 mailte Sergey Levchenko folgendes:
> Hi
>
> If I can not do insert/update action with on select rule, how can I
> execute some procedure or any sql statement on select event?
With a TRIGGER.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: on select rule
2006-04-13 15:46 on select rule Sergey Levchenko <sector119@gmail.com>
2006-04-13 21:40 ` Re: on select rule A. Kretschmer <andreas.kretschmer@schollglas.com>
@ 2006-04-14 07:00 ` Sergey Levchenko <sector119@gmail.com>
2006-04-14 07:52 ` Re: on select rule Andreas Kretschmer <akretschmer@spamfence.net>
0 siblings, 1 reply; 4+ messages in thread
From: Sergey Levchenko @ 2006-04-14 07:00 UTC (permalink / raw)
To: A. Kretschmer <andreas.kretschmer@schollglas.com>; pgsql-sql
http://www.postgresql.org/docs/8.1/interactive/sql-createtrigger.html
SELECT does not modify any rows so you can not create SELECT triggers.
Rules and views are more appropriate in such cases.
On 4/14/06, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
> am 13.04.2006, um 18:46:02 +0300 mailte Sergey Levchenko folgendes:
> > Hi
> >
> > If I can not do insert/update action with on select rule, how can I
> > execute some procedure or any sql statement on select event?
>
> With a TRIGGER.
>
>
> HTH, Andreas
> --
> Andreas Kretschmer (Kontakt: siehe Header)
> Heynitz: 035242/47215, D1: 0160/7141639
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
> === Schollglas Unternehmensgruppe ===
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: on select rule
2006-04-13 15:46 on select rule Sergey Levchenko <sector119@gmail.com>
2006-04-13 21:40 ` Re: on select rule A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-04-14 07:00 ` Re: on select rule Sergey Levchenko <sector119@gmail.com>
@ 2006-04-14 07:52 ` Andreas Kretschmer <akretschmer@spamfence.net>
0 siblings, 0 replies; 4+ messages in thread
From: Andreas Kretschmer @ 2006-04-14 07:52 UTC (permalink / raw)
To: pgsql-sql
Sergey Levchenko <sector119@gmail.com> schrieb:
> http://www.postgresql.org/docs/8.1/interactive/sql-createtrigger.htmlSELECT
> does not modify any rows so you can not create SELECT triggers.Rules
> and views are more appropriate in such cases. On 4/14/06, A.
Oh yes, i'm sorry.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-04-14 07:52 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-13 15:46 on select rule Sergey Levchenko <sector119@gmail.com>
2006-04-13 21:40 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-04-14 07:00 ` Sergey Levchenko <sector119@gmail.com>
2006-04-14 07:52 ` Andreas Kretschmer <akretschmer@spamfence.net>
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