Tom Lane deleted `array_nulls` in PostgreSQL 20, but `pg_dump` never set it, so restores into databases with it disabled silently corrupt text arrays. (I consult on PostgreSQL through PGX Inc..)

We leave the archive arc behind and enter the first of several backward-compatibility GUCs. array_nulls controls whether the array input parser treats an unquoted NULL as an actual SQL null or as...

2025年3月5日，Andrew Dunstan 提交补丁，新增参数“strip_in_arrays”，允许 json{b}_strip_nulls 移除 null 数组元素，默认为 false，设为 true 时会移除 null 元素和对象字段。示例展示了该功能的用法。

这篇博客介绍了作者在Postgres开源数据库上的工作，包括PgLife监控所有Postgres社区活动。作者在PGConf NYC上发表了关于Nulls的演讲，并提到了not in和not exists之间的null处理差异。建议在适当的情况下大量使用not null列约束来避免null问题。

How to correctly detect an SQL NULL value in PL/Perl. Handling NULLs and Empty values in PL/Perl Perl has a very simple concept of truth: everything that is a non-empty, non-zero value is...