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
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