I'm just really happy about the allowing of update when inserts conflict. This will tidy a lot of code up for me and make writing in the future that much neater.

http://www.postgresql.org/docs/9.5/static/sql-insert.html