Re: How to set a value when NULL

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, March 11, 2020, sivapostgres@xxxxxxxxx <sivapostgres@xxxxxxxxx> 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.