Hello Michael, > I have a simple SQL query: > > select * from t where 3=any(a); > > where t.a ist an array of int. > How can I write this query in JOOQ?
The above syntax will be supported by the upcoming jOOQ version 2.0.2 (release by next week): https://sourceforge.net/apps/trac/jooq/ticket/869 You can then write create.select().from(T).where(val(3).equalAny(T.A)); This will also work with H2, HSQLDB, where the above syntax simulates the explicit unnesting of arrays. Cheers Lukas
