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@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)