Sample Header Ad - 728x90

Obtain different random() values with generate_series() in PostgreSQL

2 votes
2 answers
1726 views
I am trying to generate random data (in volume) and was trying to use PostgreSQL's random() function with generate_series(), as shown:
SELECT
  (SELECT random()) AS a,
  (SELECT random()) AS b,
FROM generate_series(1,3);
However, **I get the same random values per row**:
a   |   b   
-------+-------
 0.124 | 0.443 
 0.124 | 0.443 
 0.124 | 0.443
How can this be solved?
Asked by ssn (135 rep)
Nov 10, 2021, 06:51 PM
Last activity: Aug 30, 2023, 10:11 PM