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?.
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