Re: Volatile function weirdness

2019-05-02 Thread Julien Rouhaud
On Thu, May 2, 2019 at 11:05 AM Vik Fearing wrote: > > Why do these two queries produce different results? See https://www.postgresql.org/message-id/30382.1537932...@sss.pgh.pa.us

Volatile function weirdness

2019-05-02 Thread Vik Fearing
Why do these two queries produce different results? vik=# select random(), random(), random() from generate_series(1, 5); random | random | random ---+---+--- 0.47517032455653 | 0.631991865579039 | 0.985628996044397 0.3