Re: Trigger Problem

From: Dani Oderbolz <oderbolz(at)ecologic(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Trigger Problem
Date: 2003-04-22 08:50:36
Message-ID: 3EA5025C.7030204@ecologic.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Ramesh,

just a guess:

try

IF NEW.po_no <> 'UNDEF00'

(Single quote), since you are referring to a Literal, not to a coulmn name.

Regards, Dani

--
Dani Oderbolz
IT Admin
Ecologic (www.ecologic.de)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message eurlix 2003-04-22 14:41:35 about "pg_stat_get_tuples_fetched"
Previous Message Ramesh PAtel 2003-04-22 08:27:08 Trigger Problem