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	December 9 20:29:17
Msg-id	CAKFQuwbnevkxuH8JUj4cRr8ABCAwhQTT7zM4kR0X_Le3tm7KMA@mail.gmail.com Whole thread Raw
In response to	How do I check for NULL (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Responses	Re: How do I check for NULL
List	pgsql-general

On Tue, Dec 9, 2025 at 10:14 AM Thiemo Kellner <thiemo@gelassene-pferde.biz> wrote:

I feel, you meant to say, the subquery does not return any record which is not the same as returns NULL.

For a scalar subquery the final output of a zero-row query is the null value.

David J.

From: Thiemo Kellner
Date: 09 December, 20:16:28
Subject: How do I check for NULL

From: Tzuriel Kahlon
Date: 09 December, 22:53:06
Subject: Ecpg fetch issue