From: | Michael Fork <mfork(at)toledolink(dot)com> |
---|---|
To: | Nelio Alves Pereira Filho <nelio(at)ifx(dot)com(dot)br> |
Cc: | adb <adb(at)Beast(dot)COM>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Order of Rules |
Date: | 2001-01-30 21:28:29 |
Message-ID: | Pine.BSI.4.21.0101301626370.14806-100000@glass.toledolink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Here are some good references on using triggers:
http://www.postgresql.org/docs/aw_pgsql_book/node204.html
http://www.postgresql.org/users-lounge/docs/7.0/user/c40874113.htm
These docs show you how to create a trigger, and use the information
contained in the new tuple for calculations....
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Tue, 30 Jan 2001, Nelio Alves Pereira Filho wrote:
> Yes, but how can I pass a reference of the row just inserted to the
> trigger??
>
> adb wrote:
> >
> > Sounds like you need to use a trigger set to
> > fire after the insert on table A
> >
> > Alex.
> >
> > On Tue, 30 Jan 2001, Nelio Alves Pereira Filho wrote:
> >
> > > I read at the docs that rules are executed before the query that
> > > generated them. Is there any way to change this?
> > >
> > > Here's my problem: I have two tables, A and B, and after an INSERT on
> > > table A, I want to update an specific field on table B, with the result
> > > of a sum in A. To do this I needed some information about the row just
> > > inserted, so I used rules. As my sum is running before the insertion,
> > > its result is wrong.
> > >
> > > Any ideas?
> > >
> > > Tks
> > >
> > > --
> > > Nelio Alves Pereira Filho
> > > IFX Networks - www.ifx.com.br
> > > +55 11 3365-5863
> > > nelio(at)ifx(dot)com(dot)br
> > >
>
> --
> Nelio Alves Pereira Filho
> IFX Networks - www.ifx.com.br
> +55 11 3365-5863
> nelio(at)ifx(dot)com(dot)br
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2001-01-30 21:33:07 | Re: Re: [GENERAL] Trouble porting postgreSQL to WinNT |
Previous Message | Nelio Alves Pereira Filho | 2001-01-30 21:15:01 | Re: Order of Rules |