↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

var_samp

Computes the sample variance of the input values (square of the sample standard deviation).

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 variance of the input values (square of the sample standard deviation).

Signatures and overloads

var_samp ( numeric_type ) → double precision for real or double precision, otherwise numeric
Computes the sample variance of the input values (square of the sample standard deviation).

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:33da36661c87de76ce9d85c101df865cf8af97a5f4c1fbb04570e0b73252a1da

Text language: en · wiki-repair-20261023:33da36661c87de76ce9d85c101df865cf8af97a5f4c1fbb04570e0b73252a1da