drand64

This function returns a random number using a data-slice independent 64 bit pseudo-random number generator.

Syntax

drand64(seed);

seed: A seed number used to calculate the random number.
Type: INT8)

Returns

A random value of type DOUBLE between 0.0 and 1.0. The value is based on a different prime number for each data slice. This ensures that sequences of numbers produced on any two data slices are independent.

Examples

SELECT drand64(123);

DRAND64
------------------
0.35831899940968
(1 row)