Postgres Pro
Downloads
Home   >   mailing lists

Re: How to set a value when NULL - Mailing list pgsql-general

From sivapostgres@yahoo.com
Subject Re: How to set a value when NULL
Date
Msg-id 423512419.3693197.1583927349564@mail.yahoo.com
Whole thread Raw
Responses Re: How to set a value when NULL  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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 Always
BKR Sivaprakash

pgsql-general by date:

Previous
From: Nicola Contu
Date:
Subject: Re: Streaming replication - 11.5
Next
From: Kevin Brannen
Date:
Subject: RE: Patterns to look for in the PostgreSQL server log