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.org/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.
