<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi list,</div>
<div> </div>
<div>I thought that this topic better belongs on this list.</div>
<div>I'm trying to create some random spatial data using the ST_GeneratePoints functions. I wanted to reuse it also for lines and polygons but stumbled over the issue that multiple calls of the function in one transaction produce the same result. I tested different query constructs - even looping over a PL/pgSQL function - but no luck. So whereas:</div>
<div> </div>
<div>SELECT</div>
<div> random() AS random_a,</div>
<div> random() AS random_b;</div>
<div> </div>
<div>creates different results, this:</div>
<div> </div>
<div>SELECT<br/>
ST_AsText(ST_GeneratePoints('POLYGON((0 0,1 0,1 1,0 1,0 0))'::geometry, 2)) AS random_a,<br/>
ST_AsText(ST_GeneratePoints('POLYGON((0 0,1 0,1 1,0 1,0 0))'::geometry, 2)) AS random_b;</div>
<div> </div>
<div>will produce the same. There are workaround to generate random geodata, of course.</div>
<div>Just wanted to point it out here and see, if you are aware of this. I couldn't found any ticket regarding this behaviour.</div>
<div> </div>
<div>Best, Felix</div></div></body></html>