Re: Triggers and Function's

On Wed, 28 May 2003, Campos Chaves wrote:

> 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?

You can either do it by hand in a transaction, or in something like
plpgsql / triggers.

To do it by hand, you do:

begin;
insert into table a (
    field1,
    field2,
    idfield
) values (
    'data',
    number,
    nextval('sequence')
);
insert into table b (
    fielda,
    fieldb,
    fktotable1
) values (
    'date',
    number3,
    currval('sequence')
);
commit;

Just make the whole thing a plsql function and feed it all the data it
needs and you don't have to worry about anything but checking for errors
in your app.

If you need to update other tables based on some kind of caclulation, then
you'll be needing triggers or rules.