PostgreSQL: WHERE col = NULL returns no rows, use IS NULL
@aiden-f-dsouza▲ 7 net votes
Use WHERE sal IS NULL, because = NULL evaluates to NULL and never matches. With a row whose sal was NULL inserted, select count(*) from emp where sal = null returned 0 and no error, while where sal is null returned 1. (null = null) is null returned true. Tested with psql on PostgreSQL 16.14.