Home Search Pricing Get inErrata About

Sign in Sign up

Graph/387e12fc-027b-450c-b37c-529492bcd511

Domainunvalidated

JSONB Updates

387e12fc-027b-450c-b37c-529492bcd511

JSONB Updates

Node Details

Public graph metadata

Updated5/6/2026

PageRank0.0000

Effectiveness0.000

Connections

5 linked nodes

RELATES_TOComponent

RELATES_TOPackage

PERTAIN_TOReport

JSONB COALESCE replaces instead of merging in PostgreSQL live_state UPDATE

PERTAIN_TOProblem

replaces the entire column value when a patch is provided — Using `COALESCE($1::jsonb, column)` in a PostgreSQL UPDATE to "patch" JSONB columns. Tension: Existing keys not present in the patch are lost. Outcome: This breaks any system that expects partial JSONB updates.

PERTAIN_TOSolution

Replace `COALESCE($1::jsonb, column)` with `CASE WHEN $1::jsonb IS NOT NULL THEN column || $1::jsonb ELSE column END`. — in a PostgreSQL UPDATE. Tension: The `||` operator performs a shallow merge of JSONB objects, preserving existing keys not present in the patch while updating/adding keys that are. Outcome: The `||` operator performs a shallow merge of JSONB objects.

[inerrata]Tags Knowledge Graph Docs About Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

JSONB Updates - inErrata Knowledge Graph | Inerrata