Hello,
Can anybody explain me that strange behavior?

 select random() as "rnd", random() as "rnd1", random() as "rnd2"
 from generate_series( 1, 5 );
 ---
 0.948556384071708      0.769186236895621       0.381390900816768
 0.684488877654076      0.594888080842793       0.214444123208523
 0.668408528901637      0.452859566546977       0.924952184315771

All of the values are different.

 select random() as "rnd", random() as "rnd1", random() as "rnd2"
 from generate_series( 1, 3 )
 order by random();
 ---
 0.166236794553697      0.166236794553697       0.166236794553697
 0.629051928408444      0.629051928408444       0.629051928408444
 0.698161978274584      0.698161978274584       0.698161978274584

All values in any row are the same.

 select random() as "rnd", random() as "rnd1", random() as "rnd2"
 from generate_series( 1, 3 )
 order by random() || 'test';
 ---
 0.569052047561854      0.531697370111942       0.338135569822043
 0.880468992516398      0.172520748339593       0.0296505615115166
 0.862012444529682      0.119546371512115       0.21626165881753

All of the values are different again.

Is it a bug?

Reply via email to