title: Generating unique random values along with a series - creating test data for postgresql
body: <p>I would like to generate a unique random() number for each row to be inserted into this table. Can anyone show me how I can generate the number and assign it to the <code>dis</code> field?</p>
  <p>Thanks very much!</p>
  <pre><code>DROP TABLE IF EXISTS lat_longs;
  
  CREATE TABLE lat_longs (
    id              SERIAL PRIMARY KEY,
    pos             REAL NOT NULL
    dis             REAL NOT NULL
  );
  
  insert into lat_longs(pos)
  select g.position
  from generate_series(0, 100, 0.001) as g(position);
  </code></pre>