CASE Statement in jooq?

Question

I am new in jooq So i want to write this below query in jooq .

"CASE len(CAST(SUBSTRING(attachedblob, 1, 1) AS varchar(1))) when 1 then 'true' else 'false' end  ReviewExistance "

Can you tell me please .

Thanks

Answer 1

For completeness' sake, here's how your SQL expression could translate to jOOQ:

// Assuming a static import:
import static org.jooq.impl.DSL.*;
import static org.jooq.impl.SQLDataTypes.*;

decode().value(
       length(
           cast(
               substring(MY_TABLE.ATTACHEDBLOB, 1, 1),
               VARCHAR.length(1)
           )
       )
   )
   .when(1, "true")
   .otherwise("false")
   .as("ReviewExistance");

If that's too nasty, you can always resort to plain SQL. Examples are given here:

• https://stackoverflow.com/a/19860383/521799
• https://stackoverflow.com/a/20728037/521799