just example :
Create or replace function [function_name()] returns triggers as'
begin
insert into table_b ( field1, field2, field3 ) values ( value1 , values2,
value3 ) ;
return;
end ;'
languange 'plpgsql';
Create trigger trigger_name
After Insert on [table_name]
for each row
execute procedure [function_name()];
regard...
Alam Surya
----- Original Message -----
From: "Campos Chaves" <camposchaves@yahoo.com.br>
To: <pgsql-general@postgresql.org>
Sent: Thursday, May 29, 2003 3:51 AM
Subject: [GENERAL] Triggers and Function's
Hi,
After I insert on rocord on Table A, I need to insert
another record on Table B. I think that I have to use
triggers and functions. But I don't know how! You can
help me?
Tanks
_______________________________________________________________________
Yahoo! Mail
Mais espaço, mais segurança e gratuito: caixa postal de 6MB, antivírus,
proteção contra spam.
http://br.mail.yahoo.com/
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
