Re: trigger and plpgsq help needed - Mailing list pgsql-general

From Adrian Klaver
Subject Re: trigger and plpgsq help needed
Date
Msg-id 506356E4.5040008@gmail.com
Whole thread Raw
In response to trigger and plpgsq help needed  ("SUNDAY A. OLUTAYO" <olutayo@sadeeb.com>)
List pgsql-general
On 09/26/2012 09:42 AM, SUNDAY A. OLUTAYO wrote:
> 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.

Is there a NEW.amount?

>
> Kindly help out.
>
>
>
>
> Thanks,
>
> Sunday Olutayo
>
>


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Scot Kreienkamp
Date:
Subject: Re: idle in transaction query makes server unresponsive
Next
From: Jim Wilson
Date:
Subject: Odd Invalid type name error in postgresql 9.1