Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger Problem - Mailing list pgsql-novice

From Dani Oderbolz
Subject Re: Trigger Problem
Date
Msg-id 3EA5025C.7030204@ecologic.de
Whole thread Raw
In response to Trigger Problem  ("Ramesh PAtel " <ramesh@banas.guj.nic.in>)
List pgsql-novice
Tree view 
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)

pgsql-novice by date:

Previous
From: "Ramesh PAtel "
Date:
Subject: Trigger Problem
Next
From: eurlix
Date:
Subject: about "pg_stat_get_tuples_fetched"