Jump to: navigation, search

PostgreSQL RANDOM

From w3cyberlearnings

Contents

Postgresql RANDOM

Returns random value in the range 0.0 <= x < 1.0.

Syntax RANDOM

RANDOM();

Example 1

postgres=# SELECT RANDOM(),RANDOM();
      random       |       random       
-------------------+--------------------
 0.659952891990542 | 0.0255025275982916
(1 row)



Related Links



Navigation
Web
SQL
MISC
References