3 ms·
I'm not sure if it's just sugar but PostgreSQL does allow subscripting on JSONB in UPDATE statements UPDATE characters SET jsonb_column['superpower'] =
by wild_egg 2y ago
I'm not sure if it's just sugar but PostgreSQL does allow subscripting on JSONB in UPDATE statements
UPDATE characters
SET jsonb_column['superpower'] = '"invisibility"'
WHERE id = 5;
Can't seem to find any docs around whether that still does a full rewrite under the hood or not but seemed like an important omission from your examples