↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / Mathematical Functions And Operators

random_normal

Read the PG 18 manual

Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0

Reading PG 18current·documented in 5 of 27 versions, 16 to 20

Signatures & examples

random_normal ( [ mean double precision [, stddev double precision ]] ) → double precision
Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0
random_normal(0.0, 1.0) → 0.051285419
Version history 1
  1. 15 → 16 added

Definition snapshot: b7bd9cda · English manual source