Re: Jooq Postgres 9.5+ Upsert Usage

2016-06-28 Thread Lukas Eder
Hi Samir, Indeed, very unfortunately, PostgreSQL decided against implementing the SQL standard MERGE statement and implemented their own, vendor-specific alternative. One of the very few cases where PostgreSQL goes against the standard. Thus, you cannot use jOOQ's MERGE statement. Both MySQL's O

Jooq Postgres 9.5+ Upsert Usage

2016-06-28 Thread Samir Faci
I was wondering what the status of upsert support is in Jooq. Please correct me if I'm wrong, but it sounds like there's 2 syntax for dealing with upserts. 1. http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/merge-statement/ (which I don't think is supported for postgres ) Exampl