Converting (foo & 2) bitwise operation to context sql

35 views
Skip to first unread message

a...@tranquilphotos.com

unread,
Nov 14, 2013, 12:03:06 PM11/14/13
to jooq...@googlegroups.com

Hi, 

I'm trying to convert this to JOOQ sql and cannot find the method to use: 

SELECT foo from TABLE_A where (foo & 2); 

Thanks

Lukas Eder

unread,
Nov 15, 2013, 4:30:37 AM11/15/13
to jooq...@googlegroups.com
Hello,

I'll cross-reference this discussion with the corresponding Stack Overflow question:

The answer given there is:

You can find some information about bitwise operators / bitwise functions in the relevant section of the jOOQ manual.

Concretely, using DSL.bitAnd():

DSL.bitAnd(TABLE_A.PRODUCTS, 255);
Cheers
Lukas

--
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 jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply all
Reply to author
Forward
0 new messages