在PostgreSQL 中,`json_build_object` 和 `array_agg` 是两个非常有用的函数,它们可以用来构建 JSON 对象和处理数组。然而,`distinct` 关键字不...
Just a handful of aggregates now don't support partial aggregation; postgres=# select aggfnoid from pg_aggregate where aggcombinefn=0 and aggkind='n'; aggfnoid --- xmlagg json_agg json_object_agg jsonb_agg jsonb_object_agg (5 rows) ... and a good number do support it; postgres=...