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?.
version
PostgreSQL 11.2 (Debian 11.2-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
1 rows affected
1 rows affected
id fromval toval
001 {"subject":"Foo","id":"D4014"} {"subject":"Bar","id":"D4014"}
002 {"id":"D4014","state":{"id":"GP2","name":"In progress"}} {"id":"D4014","state":{"id":"GP8","name":"Closed"}}
id ?column?
001 null
002 null
id json_each
001 (subject,"""Foo""")
001 (id,"""D4014""")
002 (id,"""D4014""")
002 (state,"{""id"":""GP2"",""name"":""In progress""}")