Re: Assistance with a trigger

chester c young wrote:
> 
> http://www.postgresql.org/docs/8.2/interactive/plpgsql.html
> 
> I found the doc to be quite good.
> 
> I'd start there, and then, if you have problems, email again.
> 

I'd read that before... but another re-read triggered a thought pattern 
and I've got it working now - it's also a lot cleaner than the SQL 
Server implementation:

CREATE OR REPLACE function fn_update_so_tran() RETURNS TRIGGER AS 
$trg_update_so_tran$
DECLARE
BEGIN   IF (NEW.tran_status = 'U') OR (NEW.tran_status = 'D') THEN      UPDATE parts_purchasing SET
qty_received=qty_received+ NEW.qty_received,         qty_invoiced = qty_invoiced + NEW.qty_invoiced,
amt_invoiced= amt_invoiced + NEW.amt_invoiced,         amt_received = amt_received + NEW.amt_received      WHERE
dealer_id= NEW.dealer_id         AND so_tran_address = NEW.so_tran_address         AND this_tran_address =
so_tran_address;  END IF;   RETURN NULL;
 
END;
$trg_update_so_tran$ LANGUAGE plpgsql;
ALTER FUNCTION fn_update_so_tran() OWNER TO "AutoDRS";

CREATE TRIGGER trg_update_so_tran AFTER INSERT OR UPDATE on 
parts_purchasing FOR EACH ROW EXECUTE PROCEDURE fn_update_so_tran();

I'm liking PostgreSQL more and more with each new thing I try :)

Thanks muchly.

-- 
Paul Lambert
Database Administrator
AutoLedgers