Variates of the Normal Distribution

The rand_norm function returns a variate of the Normal Distribution. The default value for the mean μ is 0, the default value of the standard deviation σ is 1.

The syntax of the function is

rand_norm([σ, [μ]])


SELECT rand_norm();
SELECT rand_norm(0.3);
SELECT rand_norm(0.3, 4);

 This function can only be used if the library is loaded as a plugin.