Re: trigger and plpgsq help needed

["SUNDAY A. OLUTAYO" <olutayo@xxxxxxxxxx>]

Thanks you all,

"IF last_id IS NULL THEN" eventually work

Thanks,

Sunday Olutayo
Sadeeb Technologies Ltd

---

From: "SUNDAY A. OLUTAYO" <olutayo@xxxxxxxxxx>
To: "Rob Richardson" <RDRichardson@xxxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Sent: Thursday, September 27, 2012 2:04:46 PM
Subject: Re: trigger and plpgsq help needed

RobR,

I have tried it 'IF FOUND' but not getting the desired result

Thanks,

Sunday Olutayo

---

From: "Rob Richardson" <RDRichardson@xxxxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of SUNDAY A. OLUTAYO
Sent: Wednesday, September 26, 2012 12:43 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: 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.