Search Postgresql Archives

Re: How to set a value when NULL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to set a value when NULL
From: "sivapostgres@xxxxxxxxx" <sivapostgres@xxxxxxxxx>
Date: Wed, 11 Mar 2020 11:49:09 +0000 (UTC)
References: <423512419.3693197.1583927349564.ref@mail.yahoo.com>
Reply-to: "sivapostgres@xxxxxxxxx" <sivapostgres@xxxxxxxxx>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to set a value when NULL
  - From: David G. Johnston

Prev by Date: Re: Streaming replication - 11.5
Next by Date: RE: Patterns to look for in the PostgreSQL server log
Previous by thread: Force WAL cleanup on running instance
Next by thread: Re: How to set a value when NULL
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux