On Wed, Jun 29, 2016 at 7:43 PM, Alex Ignatov <a.igna...@postgrespro.ru> wrote: > Hello! > > Got some strange behavior of random() function: > > postgres=# select (select random() ) from generate_series(1,10) as i; > random > ------------------- > 0.831577288918197 > [...] > (10 rows)
I recall that this is treated as an implicit LATERAL, meaning that random() is calculated only once. > postgres=# select (select random()+i*0 ) from generate_series(1,10) as i; > ?column? > -------------------- > 0.97471913928166 > [...] > (10 rows) But not that. So those results do not surprise me. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
