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 <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
