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
id | phones |
---|---|
1 | [{"model": "samsung s23 utra","serial_number": "12345"},{"model": "iphone15","serial_number": "12333"}] |
INSERT 0 1
ERROR: column "json_build_" does not exist LINE 1: SELECT p.id, json_build_ as phones FROM user_phones as p; ^