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

[Gavin Flower]

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