jsonb_agg_strict() — PostgreSQL aggregate aggregate function
jsonb_agg_strict(): aggregate input into jsonb skipping nulls. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
jsonb_agg_strict(): aggregate input into jsonb skipping nulls. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
jsonb_object_agg(): aggregate inputs into jsonb object. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
jsonb_object_agg_strict(): aggregate non-NULL inputs into jsonb object. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
jsonb_object_agg_unique(): aggregate inputs into jsonb object checking key uniqueness. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative…
jsonb_object_agg_unique_strict(): aggregate non-NULL inputs into jsonb object checking key uniqueness. PostgreSQL aggregate functions — signature, volatility, version applicability and an…
max(): maximum value of all bigint input values. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
min(): minimum value of all bigint input values. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
mode(): most common value. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
percentile_cont(): continuous distribution percentile. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
percentile_disc(): discrete percentile. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.