UPSERT is not a simple feature to implement correctly:

http://www.pgcon.org/2014/schedule/events/661.en.html