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?.
jsonb_pretty |
---|
{ "cars": [ { "name": "BMW" }, { "name": "Ford" }, { "name": "Fiat" } ], "dealers": [ { "dealership": "LHM" }, { "dealership": "Camp" }, { "dealership": "HMA" } ] } |
SELECT 1
data | string_agg | string_agg |
---|---|---|
{"cars": [{"name": "BMW"}, {"name": "Ford"}, {"name": "Fiat"}], "dealers": [{"dealership": "LHM"}, {"dealership": "Camp"}, {"dealership": "HMA"}]} | BMW,Ford,Fiat | LHM,Camp,HMA |
SELECT 1
?column? |
---|
Cars: BMW,Ford,Fiat // Dealers: LHM,Camp,HMA |
SELECT 1