Comments by Ferenc Rózsa (Top 1 by date)

I used sqlfiddle for an example. I tried it also in postgresql with my real data without luck. I seems to me that update isn't able to update the same row multiple times in the destination table.