Thanks you all, " IF last_id IS NULL THEN " eventually work
Thanks, Sunday Olutayo Sadeeb Technologies Ltd ----- Original Message ----- From: "SUNDAY A. OLUTAYO" <[email protected]> To: "Rob Richardson" <[email protected]> Cc: [email protected] Sent: Thursday, September 27, 2012 2:04:46 PM Subject: Re: [GENERAL] trigger and plpgsq help needed RobR, I have tried it 'IF FOUND' but not getting the desired result Thanks, Sunday Olutayo ----- Original Message ----- From: "Rob Richardson" <[email protected]> To: [email protected] Sent: Wednesday, September 26, 2012 7:14:46 PM Subject: Re: [GENERAL] trigger and plpgsq help needed Why not use IF FOUND? RobR From: [email protected] [mailto:[email protected]] On Behalf Of SUNDAY A. OLUTAYO Sent: Wednesday, September 26, 2012 12:43 PM To: [email protected] Subject: [GENERAL] trigger and plpgsq help needed Dear all, I have issue with the red portion function below; This IF last_id IS NULL THEN suppose to test if last_id is NULL, that is the select query did not found it then execute the rest of the red sql but it always fail to insert the NEW.amount into amount , every other things fine. Kindly help out.
