Hello, Thanks for your messages. Indeed, these are known limitations of jOOQ version 3.9, which will be fixed in version 3.10:
- ON CONFLICT .. RETURNING: #2123 <https://github.com/jOOQ/jOOQ/issues/2123> - ON CONFLICT .. WHERE: #5637 <https://github.com/jOOQ/jOOQ/issues/5637> ON CONFLICT .. WHERE is already available from GitHub master. Returning could be achieved (I haven't tested) by casting the type of your DSL step to the relevant type that contains the returning() clause, or by using the model API rather than the DSL API, through DSLContext.insertQuery(). I believe that the RETURNING limitation is a mere limitation of the DSL API. Hope this helps, Lukas 2017-03-01 19:58 GMT+01:00 Emrul Islam <[email protected]>: > Opened a GH issue for this https://github.com/jOOQ/jOOQ/issues/5933 > > In the meantime, if there's a workaround I'll happily take it - I am > having to convert my insert statement to a String and append the WHERE and > RETURNING clauses. > > > > On Tuesday, February 28, 2017 at 9:22:40 PM UTC, Emrul Islam wrote: >> >> Also, I can't seem to add a RETURNING statement if I use .onConflict(). >> doUpdate().set().. >> >> On Tuesday, February 28, 2017 at 8:11:03 PM UTC, Emrul Islam wrote: >>> >>> Hi, >>> >>> Progressing with my current project and run into one more snag - I need >>> to do an UPSERT as defined here: https://www.postgresql.o >>> rg/docs/current/static/sql-insert.html#SQL-ON-CONFLICT and I need to be >>> able to do DO UPDATE SET ... *WHERE*. Seems that the ability to add >>> the WHERE might be missing from the class InsertOnDuplicateSetMoreStep >>> >>> As usual, I think I can work around it for now and move forward but >>> would be handy to get this in a future release. >>> >>> Thanks >>> >> -- > 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/d/optout. > -- 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/d/optout.
