Trigger Function

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