↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

stddev_pop

Computes the population standard deviation of the input values.

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

group
aggregate
group label
聚合函数
lang
en
layout
table-new
pages
functions-aggregate.html
prose only
false

Definition PG 18

Computes the population standard deviation of the input values.

Signatures and overloads

stddev_pop ( numeric_type ) → double precision for real or double precision, otherwise numeric
Computes the population standard deviation of the input values.

Compare versions

Complete source facts

documentation revision

{"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"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:ff09389c8aac27a90786bbcbe77eeb24cb2f027804fadca17188fc7ce0f1a211

Text language: en · wiki-repair-20261023:ff09389c8aac27a90786bbcbe77eeb24cb2f027804fadca17188fc7ce0f1a211