↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

stddev_samp

Computes the sample 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 sample standard deviation of the input values.

Signatures and overloads

stddev_samp ( numeric_type ) → double precision for real or double precision, otherwise numeric
Computes the sample 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:06a25b74aa25d2116de919f2c51c3414d249777d4f2aecf8924b3a4d753fe8c2

Text language: en · wiki-repair-20261023:06a25b74aa25d2116de919f2c51c3414d249777d4f2aecf8924b3a4d753fe8c2