Hi, I would like to write a simple select statement using the IN operator. [select * from X where id1 = 21 and id2 in (1,2) ]
I tried the following: create.select().from(view).where(whereClause, whereBindings); whereClause = id1 = ? and id2 in ? whereBindings[0] = 21L whereBinding[1] = "(1,2)" Which resulted with: select * from X where (id1 = 21 and id2 in '(1,2)') What is the proper way to write such a query? Thanks! Liran -- 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.
