Problem with postgreSQL triggers

From: Sbastien BOUTELOUP <Sebastien(dot)Bouteloup(at)upmf-grenoble(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: Problem with postgreSQL triggers
Date: 1999-08-12 11:39:53
Message-ID: 99081213542902.31731@iepe-pc18.upmf-grenoble.fr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello,
I have some trouble with postgresql triggers:
I just want to execute an sql query (insert) in a trigger and I don't manage to
write the corresponding procedure.
Is it possible to use the traditionnal structure:
create trigger <trigger name>
before delete on <table name>
for each row
BEGIN
query;
END; ?
Otherwise, how can I deal with the "execute procedure <procedure name>"
statement?
Thanks

-----------------------------------------
Sbastien BOUTELOUP
stagiaire l'UFR DGES
lve ingnieur 2me anne ENSIMAG

tl: 04.76.51.49.61

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Ogryczak 1999-08-12 12:32:22 converting text to float?
Previous Message KOUL Christian 1999-08-12 07:07:38 shared tables?