Re: How to set a value when NULL
Hello,Need to set a value of Zero when the field value is NULL in trigger function.
Tried with,NEW.fieldname = NULLIF(NEW.fieldname, 0)
in before insert/update trigger.
Looks like it's not working. I'm doing anything wrong.
Happiness AlwaysBKR Sivaprakash
Import Notes
Reference msg id not found: 423512419.3693197.1583927349564.ref@mail.yahoo.com
On Wednesday, March 11, 2020, sivapostgres@yahoo.com <sivapostgres@yahoo.com>
wrote:
Hello,
Need to set a value of Zero when the field value is NULL in trigger
function.Tried with,
NEW.fieldname = NULLIF(NEW.fieldname, 0)in before insert/update trigger.
Looks like it's not working. I'm doing anything wrong
NULLIF does the inverse of what you want - you expression returns null if
fieldna,e has a value of 0.
COALESCE is what you want.
Coalesce(fieldname, 0) — returns the first, non-null argument.
David J.