Advertisement
hd1

joining columns/hd1

hd1
Mar 2nd, 2014
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Results I want:
  2. location            | titles
  3. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  4.  -0.08776, 43.53336 | "Manchester United beat Everton 2 - 0", "Wayne Rooney scores 2 against Everton"
  5.  
  6. Database looks like:
  7.  
  8. longitude | latitude | title
  9.  -0.08776 | 43.53336 | Manchester United beat Everton 2 - 0
  10.  -0.08776 | 43.53336 | Wayne Rooney scores 2 against Everton
  11.  
  12. Solved at http://www.prolificprogrammer.com/2014/03/how-to-do-pivot-tables-in-postgres.html
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement