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 test1 (id integer, value text);
insert into test1 values
(1, 'xyz'), (2, 'xxy');
create table test2 (id integer, value text);
insert into test2 values
(3, 'yyy'), (4, 'yxy');
CREATE TABLE
INSERT 0 2
CREATE TABLE
INSERT 0 2
select json_agg (json_build_object(
'ID', t1.id,
'someText', t1.value )) as jbo
from test1 t1
| jbo |
|---|
| [{"ID" : 1, "someText" : "xyz"}, {"ID" : 2, "someText" : "xxy"}] |
SELECT 1