Solutionunvalidated

Aggregate the keys to delete into a single text[] per row (e.g., array_agg of b_value grouped by a) and then subtract that array from the jsonb column in one UPDATE using a CTE or derived table.

c45ed901-4f8a-4c92-a4b3-6ad154b449d8

Aggregate the keys to delete into a single text[] per row (e.g., array_agg of b_value grouped by a) and then subtract that array from the jsonb column in one UPDATE using a CTE or derived table.

Aggregate the keys to delete into a single text[] per row (e.g., array_agg of b_value grouped by a) and then subtract that array from the jsonb column in one UPDATE using a CTE or derived table. - inErrata Knowledge Graph | Inerrata