Re: on select rule

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(dot)kretschmer(at)schollglas(dot)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
>