{"Entry":{"collection":"func","key":"percentile-cont","name":"percentile_cont","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.3","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.4"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"e23af9953668d2a0bc844610850bbc952923933ad36a7b3db97450817deef37f","first_version":"9.4","group":"aggregate","group_label":"Aggregate Functions","groups":["aggregate"],"imported_at":"2026-09-14T21:49:48.863027+08:00","last_version":"20","name":"percentile_cont","name_key":"percentile_cont","position":21034,"present_in":["9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY double precision ) → double precision","signature_count":4,"slug":"percentile-cont","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","summary":"Computes the continuous percentile, a value corresponding to the specified fraction within the ordered set of aggregated argument values.","summary_zh":""}},"Definition":{"Collection":"func","Key":"percentile-cont","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"percentile-cont","SourceRevision":"2026-09-14T13:14:25.684213+00:00@99e6866c","Facts":{"description":"Computes the continuous percentile, a value corresponding to the specified fraction within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_html":"Computes the \u003cem class=\"firstterm\"\u003econtinuous percentile\u003c/em\u003e, a value corresponding to the specified \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ORDEREDSET-TABLE","file":"functions-aggregate.html","slug":"18"},"group":"aggregate","group_label":"Aggregate Functions","lang":"en","layout":"table-new","pages":["functions-aggregate.html"],"prose_only":false,"signatures":[{"description":"Computes the continuous percentile, a value corresponding to the specified fraction within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_html":"Computes the \u003cem class=\"firstterm\"\u003econtinuous percentile\u003c/em\u003e, a value corresponding to the specified \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epercentile_cont\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e ) \u003ccode class=\"literal\"\u003eWITHIN GROUP\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003edouble precision\u003c/code\u003e","returns":"double precision","text":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY double precision ) → double precision","zh_from":""},{"description":"Computes the continuous percentile, a value corresponding to the specified fraction within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_html":"Computes the \u003cem class=\"firstterm\"\u003econtinuous percentile\u003c/em\u003e, a value corresponding to the specified \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epercentile_cont\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e ) \u003ccode class=\"literal\"\u003eWITHIN GROUP\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einterval\u003c/code\u003e","returns":"interval","text":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY interval ) → interval","zh_from":""},{"description":"Computes multiple continuous percentiles. The result is an array of the same dimensions as the fractions parameter, with each non-null element replaced by the (possibly interpolated) value corresponding to that percentile.","description_html":"Computes multiple continuous percentiles. The result is an array of the same dimensions as the \u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e parameter, with each non-null element replaced by the (possibly interpolated) value corresponding to that percentile.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epercentile_cont\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision[]\u003c/code\u003e ) \u003ccode class=\"literal\"\u003eWITHIN GROUP\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003edouble precision[]\u003c/code\u003e","returns":"double precision[]","text":"percentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY double precision ) → double precision[]","zh_from":""},{"description":"Computes multiple continuous percentiles. The result is an array of the same dimensions as the fractions parameter, with each non-null element replaced by the (possibly interpolated) value corresponding to that percentile.","description_html":"Computes multiple continuous percentiles. The result is an array of the same dimensions as the \u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e parameter, with each non-null element replaced by the (possibly interpolated) value corresponding to that percentile.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epercentile_cont\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision[]\u003c/code\u003e ) \u003ccode class=\"literal\"\u003eWITHIN GROUP\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einterval[]\u003c/code\u003e","returns":"interval[]","text":"percentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY interval ) → interval[]","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ORDEREDSET-TABLE","file":"functions-aggregate.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"percentile-cont","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"percentile_cont","Summary":"计算连续百分位点，该值对应于聚合参数值有序集合中的指定fraction。必要时会在相邻输入项之间进行插值。","BodyHTML":"计算\u003cem\u003e连续百分位点\u003c/em\u003e，该值对应于聚合参数值有序集合中的指定\u003cem\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e。必要时会在相邻输入项之间进行插值。\u003cpre\u003epercentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY double precision ) → double precision\u003c/pre\u003e计算\u003cem\u003e连续百分位点\u003c/em\u003e，该值对应于聚合参数值有序集合中的指定\u003cem\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e。必要时会在相邻输入项之间进行插值。\u003cpre\u003epercentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY interval ) → interval\u003c/pre\u003e计算\u003cem\u003e连续百分位点\u003c/em\u003e，该值对应于聚合参数值有序集合中的指定\u003cem\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e。必要时会在相邻输入项之间进行插值。\u003cpre\u003epercentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY double precision ) → double precision[]\u003c/pre\u003e计算多个连续百分位点。结果是一个与\u003cem\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e参数具有相同维度的数组，其中每个非 null 元素都被替换为对应百分位点的值（必要时会进行插值）。\u003cpre\u003epercentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY interval ) → interval[]\u003c/pre\u003e计算多个连续百分位点。结果是一个与\u003cem\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e参数具有相同维度的数组，其中每个非 null 元素都被替换为对应百分位点的值（必要时会进行插值）。","SourceRevision":"ca936764","ContentHash":"d415a8b95245a0ac38dafc7a58de15eb1ceeef0db92413b73dd97b504aaa654d","Payload":{"description_zh":"计算连续百分位点，该值对应于聚合参数值有序集合中的指定fraction。必要时会在相邻输入项之间进行插值。","description_zh_html":"计算\u003cem class=\"firstterm\"\u003e连续百分位点\u003c/em\u003e，该值对应于聚合参数值有序集合中的指定\u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e。必要时会在相邻输入项之间进行插值。","signatures":[{"description_zh":"计算连续百分位点，该值对应于聚合参数值有序集合中的指定fraction。必要时会在相邻输入项之间进行插值。","description_zh_html":"计算\u003cem class=\"firstterm\"\u003e连续百分位点\u003c/em\u003e，该值对应于聚合参数值有序集合中的指定\u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e。必要时会在相邻输入项之间进行插值。","returns":"double precision","text":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY double precision ) → double precision","zh_from":"doc"},{"description_zh":"计算连续百分位点，该值对应于聚合参数值有序集合中的指定fraction。必要时会在相邻输入项之间进行插值。","description_zh_html":"计算\u003cem class=\"firstterm\"\u003e连续百分位点\u003c/em\u003e，该值对应于聚合参数值有序集合中的指定\u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e。必要时会在相邻输入项之间进行插值。","returns":"interval","text":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY interval ) → interval","zh_from":"doc"},{"description_zh":"计算多个连续百分位点。结果是一个与fractions参数具有相同维度的数组，其中每个非 null 元素都被替换为对应百分位点的值（必要时会进行插值）。","description_zh_html":"计算多个连续百分位点。结果是一个与\u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e参数具有相同维度的数组，其中每个非 null 元素都被替换为对应百分位点的值（必要时会进行插值）。","returns":"double precision[]","text":"percentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY double precision ) → double precision[]","zh_from":"doc"},{"description_zh":"计算多个连续百分位点。结果是一个与fractions参数具有相同维度的数组，其中每个非 null 元素都被替换为对应百分位点的值（必要时会进行插值）。","description_zh_html":"计算多个连续百分位点。结果是一个与\u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e参数具有相同维度的数组，其中每个非 null 元素都被替换为对应百分位点的值（必要时会进行插值）。","returns":"interval[]","text":"percentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY interval ) → interval[]","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"6339fc332299a669f4388e9f3c527bc81f4927bb7b63185f4b1cecfbc9f7ad8e","Text":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY double precision ) → double precision","Returns":"double precision","Payload":{"description":"Computes the continuous percentile, a value corresponding to the specified fraction within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_html":"Computes the \u003cem class=\"firstterm\"\u003econtinuous percentile\u003c/em\u003e, a value corresponding to the specified \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epercentile_cont\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e ) \u003ccode class=\"literal\"\u003eWITHIN GROUP\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003edouble precision\u003c/code\u003e","returns":"double precision","text":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY double precision ) → double precision","zh_from":""}},{"Version":"18","Ordinal":1,"Hash":"98ed5e3d593737948504e85032344a86fa1ab156613cab22af953b4b6e2b6878","Text":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY interval ) → interval","Returns":"interval","Payload":{"description":"Computes the continuous percentile, a value corresponding to the specified fraction within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_html":"Computes the \u003cem class=\"firstterm\"\u003econtinuous percentile\u003c/em\u003e, a value corresponding to the specified \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e within the ordered set of aggregated argument values. This will interpolate between adjacent input items if needed.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epercentile_cont\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efraction\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e ) \u003ccode class=\"literal\"\u003eWITHIN GROUP\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einterval\u003c/code\u003e","returns":"interval","text":"percentile_cont ( fraction double precision ) WITHIN GROUP ( ORDER BY interval ) → interval","zh_from":""}},{"Version":"18","Ordinal":2,"Hash":"86dd3edae794c6cbdee3237a2ce87308743c8c5a279b19851907c95fcdfbc54b","Text":"percentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY double precision ) → double precision[]","Returns":"double precision[]","Payload":{"description":"Computes multiple continuous percentiles. The result is an array of the same dimensions as the fractions parameter, with each non-null element replaced by the (possibly interpolated) value corresponding to that percentile.","description_html":"Computes multiple continuous percentiles. The result is an array of the same dimensions as the \u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e parameter, with each non-null element replaced by the (possibly interpolated) value corresponding to that percentile.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epercentile_cont\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision[]\u003c/code\u003e ) \u003ccode class=\"literal\"\u003eWITHIN GROUP\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003edouble precision[]\u003c/code\u003e","returns":"double precision[]","text":"percentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY double precision ) → double precision[]","zh_from":""}},{"Version":"18","Ordinal":3,"Hash":"b80c98e61eafca5984652a1a19fbb47fa728b901276c5e26ac723707539e8842","Text":"percentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY interval ) → interval[]","Returns":"interval[]","Payload":{"description":"Computes multiple continuous percentiles. The result is an array of the same dimensions as the fractions parameter, with each non-null element replaced by the (possibly interpolated) value corresponding to that percentile.","description_html":"Computes multiple continuous percentiles. The result is an array of the same dimensions as the \u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e parameter, with each non-null element replaced by the (possibly interpolated) value corresponding to that percentile.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epercentile_cont\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003efractions\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision[]\u003c/code\u003e ) \u003ccode class=\"literal\"\u003eWITHIN GROUP\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einterval[]\u003c/code\u003e","returns":"interval[]","text":"percentile_cont ( fractions double precision[] ) WITHIN GROUP ( ORDER BY interval ) → interval[]","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}