Re: [postgis-users] Query with LIMIT but as random result set? - Mailing list pgsql-general

On 01/11/13 09:31, Gavin Flower wrote:
> -- theta in radians
> -- for radius = 100
>
> INSERT INTO ranpoint
>      (id, theta, r)
> VALUES
>      (generate_series(1, 10), pi() * random(), 100 * random());

Shouldn't the value for theta be:
     2 * pi() * random()

Bosco.