Postgres Pro
Downloads
Home   >   mailing lists

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

From Rob Richardson
Subject Re: trigger and plpgsq help needed
Date
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBD1FDC84D3@RADCONWIN2K8PDC.radcon.local
Whole thread Raw
In response to trigger and plpgsq help needed  ("SUNDAY A. OLUTAYO" <olutayo@sadeeb.com>)
Responses Re: trigger and plpgsq help needed  ("SUNDAY A. OLUTAYO" <olutayo@sadeeb.com>)
List pgsql-general
Tree view

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.

Kindly help out.

pgsql-general by date:

Previous
From: Chris Ernst
Date:
Subject: Re: trigger and plpgsq help needed
Next
From: Robert Sosinski
Date:
Subject: Inaccurate Explain Cost