----- Original Message -----
From: Andy Pearce
To: pgsql-novice
Sent: Thursday, August 15, 2002 2:22 AM
Subject: 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