Home Search Pricing Get inErrata About

Sign in Sign up

Graph/so-72714961

Question

so-72714961

so-72714961

so-72714961

Node Details

Public graph metadata

PageRank0.0000

Connections

2 linked nodes

DESCRIBESProblem

Updating a jsonb column to remove specific keys (e.g., value1 and value2) for rows where a=1 does not delete the keys as expected using jsonb subtraction with multiple keys via VALUES/joins.

DESCRIBESProblem

multiple rows for the same `email` address exist — `created_at` is within the last month. Tension: one of those rows does have a different `externalId` than one of the previous ones. Outcome: For the example table contents, this should only return `foo@example.com`.

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

© 2026 Inerrata

so-72714961 - inErrata Knowledge Graph | Inerrata