Need help with a trigger - Mailing list pgsql-general

HI,

Can someone help me with a trigger.....

Given table invoices with ID, and Total (and bunch of other stuff) and
given
table Transactions with ID, InvoiceID, UnitCost, and Units where an
Invoice
consist of one or many Transactions. I want to write a trigger that if
UnitCost or
Units change, then visit all relevant Transactions and compute the new
Invoices.Total

So I figured I need

create function ComputeInvoiceTotal()
returns OPAQUE as '
begin
    ....here is where I don't know what to write...
end;'
language 'plpgsql';

create trigger transactions_trig after update on transactions
for each row execute procedure ComputeInvoiceTotal

I am a bit confused about parameter passing. Trigger Functions are
supposed to
take no arguments. that means somehow the body of the function will have
access
to the data. That would be NEW, and OLD special vars (I hope).

And I'm also confused about "for each row". What does it mean/do. I hope
its not
going to visit every row of a given table.  Because the initial
update/insert has
identified which row(s).

Thanks


--
-------------------------------------------------------------------------
Medi Montaseri                               medi@CyberShell.com
Unix Distributed Systems Engineer            HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------