Request a Demo
Home   >   mailing lists

Re: How do I check for NULL - Mailing list pgsql-general

From David G. Johnston
Subject Re: How do I check for NULL
Date
Msg-id CAKFQuwa0QT01k7yVQJOQ2oMeQQWOQ+NSeYYyY3-8sqNYLQvBOA@mail.gmail.com
Whole thread Raw
In response to How do I check for NULL  (Igor Korot <ikorot01@gmail.com>)
Responses Re: How do I check for NULL
List pgsql-general
Tree view
On Monday, December 8, 2025, Igor Korot <ikorot01@gmail.com> wrote:

However,, I'd like to still insert the record and I'd like to do something like:

INSERT INTO test VALUES( 0, 'abc', 12345, IF( (SELECT foo FROM bar) ==
NULL, "postgres", <select_result>), /*more data follow*/);

What would be the best way to achieve this?

The “coalesce” function.

David J.
 

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: How do I check for NULL
Next
From: Ron Johnson
Date:
Subject: Re: How do I check for NULL