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. The aggregated argument must be of a sortable type.
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
fraction. The aggregated argument must be of a sortable type.percentile_disc ( fraction double precision ) WITHIN GROUP ( ORDER BY anyelement ) → 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 ) → anyarray → 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.{"inputs":[{"file":"functions-aggregate.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"31d3dcd36ef353484b4b3535f9f0d1cc239c3910146257fe5178f99b90b501e2","version":"18.7"},{"file":"functions-aggregate.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"0bf7506d27b71666fc74840a21a8f77c8a92735174f1d05033865961722e457c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:5836aafd81f17009dd6b9eaa121087a0bc79fec922beb98c446a9ac64a88d30c
Text language: en · wiki-repair-20261023:5836aafd81f17009dd6b9eaa121087a0bc79fec922beb98c446a9ac64a88d30c