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

[Gavin Flower <GavinFlower@xxxxxxxxxxxxxxxxx>]

On 12/01/13 06:45, Bosco Rama wrote:

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.

Very definitely!  :-)

Me bad, as the saying goes...


Cheers,
Gavin