add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE
INSERT 0 1
ERROR:  syntax error at end of input
LINE 13: --where  ct.id = t.id;
                               ^
id data
1 [{"id": "1", "status": "test status1", "updatedAt": "1571145003"}, {"id": "2", "status": "test status2", "updatedAt": "1571145323"}]
SELECT 1
UPDATE 1
id data
1 [{"id": "1", "status": "test status1", "updatedAt": "1571150000"}, {"id": "2", "status": "test status2", "updatedAt": "1571150000"}]
SELECT 1