Removing nulls from JSON arrays – coming in PostgreSQL 18

by fforfloon 3/16/2025, 11:43 AMwith 1 comments

by fforfloon 3/16/2025, 11:43 AM

PostgreSQL 18 won't have many JSON enhancements - how much better can it get after all? And virtual generated columns will probably be the highlight of the release. But there's always some room for improvement. One long-standing pain point has been simply removing nulls from JSON arrays.