Michael Cramer michael@bigmichi1.de writes:

anybody knows how this can be achieved with postgresql, because 'ON DUPLICATE KEY UPDATE' syntax is mysql specific

A clear, concise explanation of consistency problems with SQL update-or-insert ("upsert") operation, including a PostgreSQL implementation:

http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/

Joseph Tam jtam.home@gmail.com