Re: Triggers and Function's

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(at)yahoo(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)