Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Results I want:
- location | titles
- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- -0.08776, 43.53336 | "Manchester United beat Everton 2 - 0", "Wayne Rooney scores 2 against Everton"
- Database looks like:
- longitude | latitude | title
- -0.08776 | 43.53336 | Manchester United beat Everton 2 - 0
- -0.08776 | 43.53336 | Wayne Rooney scores 2 against Everton
- 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