Fw: Trigger Function

From: "Andy Pearce" <andyj(at)basesys(dot)co(dot)uk>
To: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Fw: Trigger Function
Date: 2002-08-26 22:02:06
Message-ID: 001601c24d4c$397d4740$0200a8c0@dellboy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm attemptimg my first trigger funtion and so far it keeps crashing the backend.

This is the function:

CREATE FUNCTION acc_transaction_trig() RETURNS opaque AS '

begin

update customer_accounts set customer_acounts.forecast_balance = (customer_accounts.forecast_balance - NEW.transaction_value)

where customer_accounts.account_num = NEW.account_num;

return NEW;

end;

' LANGUAGE 'plpgsql';

Does this look wrong in anyway?

Any assistance would be gladly appreciated.

Thanks

Andy

Browse pgsql-novice by date

  From Date Subject
Next Message Warren Massengill 2002-08-27 01:21:24 interface choices
Previous Message Josh Berkus 2002-08-26 20:33:52 Re: functions