From: "SUNDAY A. OLUTAYO" <olutayo@sadeeb.com> To: "Rob Richardson" <RDRichardson@rad-con.com> Cc: pgsql-general@postgresql.org Sent: Thursday, September 27, 2012 2:04:46 PM Subject: Re: [GENERAL] trigger and plpgsq help needed
p { margin: 0; }
RobR,
I have tried it 'IF FOUND' but not getting the desired result
Thanks,
Sunday Olutayo
From: "Rob Richardson" <RDRichardson@rad-con.com> To: pgsql-general@postgresql.org Sent: Wednesday, September 26, 2012 7:14:46 PM Subject: Re: [GENERAL] trigger and plpgsq help needed
Why not use IF FOUND?
RobR
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of SUNDAY A. OLUTAYO Sent: Wednesday, September 26, 2012 12:43 PM To: pgsql-general@postgresql.org 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.