Re: Random function

2020-03-24 Thread David G. Johnston
How is this a performance related question? On Tue, Mar 24, 2020 at 11:10 AM Luis Roberto Weck < luisrobe...@siscobra.com.br> wrote: > However, I am getting the same result over mulitiple rows. This is a > sample of the SQL I am using: > > select (select string_agg(random()::text,';') >

Re: Random function

2020-03-24 Thread Tom Lane
Luis Roberto Weck writes: > I am trying to generate some random data using the random() function. > However, I am getting the same result over mulitiple rows. This is a > sample of the SQL I am using: > select (select string_agg(random()::text,';') > from pg_catalog.generate_series(1,3,