Hello, There are two long-term feature requests for the emulation of the SQL standard MERGE: - https://github.com/jOOQ/jOOQ/issues/1067
... and for MySQL's INSERT .. ON DUPLICATE KEY UPDATE: - https://github.com/jOOQ/jOOQ/issues/558 This is not a high priority at the moment. Besides, we're not sure if such emulation can be done reliably. Another way to perform "upsert" in CRUD contexts, is to simply use UpdatableRecord.store(): http://www.jooq.org/javadoc/latest/org/jooq/UpdatableRecord.html#store() Regards, Lukas 2014-02-18 2:48 GMT+01:00 Vijay Ganesan <[email protected]>: > > Anyone have an example of using JOOQ to achieve upsert (insert or update) > with Postgres? Postgres does not have native support for upsert. > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
