SQL NULL & JSON NULL

nulls-nulls-everywhere.sql

SELECT
  jsonb_set(
    '{"deeply": {"nested": {"field": 1}}}'::jsonb,
    '{deeply,nested,field}',
    to_jsonb(NULL::int)
  ) AS with_null_arg,

  jsonb_set(
    '{"deeply": {"nested": {"field": 1}}}'::jsonb,
    '{deeply,nested,field}',
    to_jsonb(1234::int)
  ) AS sans_null_arg;
  
-- ┌───────────────┬─────────────────────────────────────────┐
-- │ with_null_arg │              sans_null_arg              │
-- ├───────────────┼─────────────────────────────────────────┤
-- │ 𝗡𝗨𝗟𝗟          │ {"deeply": {"nested": {"field": 1234}}} │
-- └───────────────┴─────────────────────────────────────────┘