title: Randomize Two Data Sets
body: <p>I am trying to come up with a way to assign two people together from a larger dataset of about 6 people. I was toying around with the random() function in postgres but had no luck. I have access to postgres or oracle whichever may be easier to accomplish this. 
  For example if I had 6 names I'd like to take those 6 names and assign them to one another using some sort of randomizing query:</p>
  
  <ol>
  <li>Billy</li>
  <li>Bob</li>
  <li>Joe</li>
  <li>Sam</li>
  <li>John</li>
  <li>Alex</li>
  </ol>
  
  <p>The output would be something along the lines of:</p>
  
  <p>Orignal Name | Match</p>
  
  <ol>
  <li>Billy    | Alex</li>
  <li>Bob      | Joe</li>
  <li>Joe      | John</li>
  <li>Sam      | Bob</li>
  <li>John     | Billy</li>
  <li>Alex     | Sam</li>
  </ol>
  
  <p>Any help would be greatly appreciated!</p>
  
  <p>Thank you.</p>