Working with NULL - PostgreSQL for Developers
Working with NULL - part of PostgreSQL for Developers.
PostgreSQL from the inside out - fundamentals through internals and ops.
In this lesson:
NULL means unknown — any comparison with equals NULL yields NULL, never TRUE
Always use IS NULL or IS NOT NULL to filter unknown values
Use COALESCE to substitute a default and NULLIF to convert a sentinel into NULL
Chapters:
0:00 Intro
0:11 NULL means unknown, not absent
0:23 Under the hood: three-valued logic in the executor
0:40 NULL comparisons in action
0:55 COALESCE and NULLIF
1:11 Review lens: spotting the NULL bug in a pull request
1:24 Recap
Module: SQL Fundamentals
Every command and code example in this video is executed and verified before publishing.
On this page of the site you can watch the video online Working with NULL - PostgreSQL for Developers with a duration of hours minute second in good quality, which was uploaded by the user The Software Mentor 02 July 2026, share the link with friends and acquaintances, this video has already been watched 6 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
