How do I check for NULL

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How do I check for NULL
Date: 2025-12-09 17:14:27
Message-ID: aa20cf3d-20ab-4788-bab0-60e478c9f125@gelassene-pferde.biz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

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

In any case, I suggest you to use the "insert select" construct, see examples in https://www.postgresql.org/docs/current/sql-insert.html, e.g. "NSERT INTO films SELECT * FROM tmp_films WHERE date_prod < '2004-05-07';"

Cheers

Thiemo

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner 2025-12-09 17:16:28 How do I check for NULL
Previous Message Adrian Klaver 2025-12-09 16:09:51 Re: How do I check for NULL