jOOQ has DSLContext.fetchExists(Select<?>) if you want to make that a standalone call: http://www.jooq.org/javadoc/latest/org/jooq/DSLContext.html#fetchExists-org.jooq.Select-
This was added in jOOQ 3.5 If you want to embed your EXISTS predicate in a bigger SELECT, you can combine: - http://www.jooq.org/javadoc/latest/org/jooq/impl/DSL.html#exists-org.jooq.Select- - http://www.jooq.org/javadoc/latest/org/jooq/impl/DSL.html#field-org.jooq.Condition- As in: Field<Boolean> field = field( exists( selectOne().from(CONTACT).where(CONTACT.ID.eq(12)) ) ); Hope this helps, Lukas 2014-12-16 9:56 GMT+01:00 Marcel Huber <[email protected]>: > > referring to http://stackoverflow.com/a/16467634/426834 "select exists" > returns "true" or "false" for the subquery. What is the idiomatic > equivalent in jooq? > > -- > 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.
