| From: | Luis Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br> |
|---|---|
| To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Random function |
| Date: | 2020-03-24 18:10:16 |
| Message-ID: | 95311e45-95e3-970b-e54f-3a4595d55dbb@siscobra.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
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,1) )
from generate_series(1,10,1)
And I am getting something like:
|string_agg |
+--------------------------------------------------------------+
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
|0.243969671428203583;0.692578794434666634;0.291524752043187618|
If this is the expected output, is there a way to always generate random
numbers?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-03-24 18:33:11 | Re: Random function |
| Previous Message | Thomas Kellerer | 2020-03-23 16:33:34 | Re: JOIN on partitions is very slow |