Computes the discrete percentile, the first value within the ordered set of aggregated argument values whose position in the ordering equals or exceeds the specified fraction.
percentile_disc ( fraction double precision ) WITHIN GROUP ( ORDER BY anyelement ) → anyelementComputes the discrete percentile, the first value within the ordered set of aggregated argument values whose position in the ordering equals or exceeds the specified
fraction. The aggregated argument must be of a sortable type.percentile_disc ( fractions double precision[] ) WITHIN GROUP ( ORDER BY anyelement ) → anyarrayComputes multiple discrete percentiles. The result is an array of the same dimensions as the
fractions parameter, with each non-null element replaced by the input value corresponding to that percentile. The aggregated argument must be of a sortable type.Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source