Hmm, no, that syntax isn't supported (yet). Perhaps we might add support in the next version. It should be rather simple to emulate: https://github.com/jOOQ/jOOQ/issues/4245
In the meantime, you'll need to resort to a classic semi-join using IN or EXISTS: DELETE FROM pending_invites i WHERE i.registrant = ? AND i.msisdn IN (SELECT u.msisdn FROM users u WHERE u.id = ?); Hope this helps, Lukas 2015-04-28 13:23 GMT+02:00 Ben Hood <[email protected]>: > Hi Lukas, > > I'm trying to encode the following DELETE with a join using the > Postgres syntax in the JOOQ DSL: > > DELETE FROM pending_invites i > USING users u > WHERE i.registrant = ? > AND u.id = ? > AND u.msisdn = i.msisdn; > > Is there a JOOQ DSL example somewhere for this Postgres specific syntax? > > Cheers, > > Ben > > -- > 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.
