Hello Vijay, Constants / bind values can be created using DSL.val() or DSL.inline(). See the relevant sections of the manual and Javadocs:
- http://www.jooq.org/doc/latest/manual/sql-building/bind-values - http://www.jooq.org/javadoc/latest/org/jooq/impl/DSL.html#val(T) - http://www.jooq.org/javadoc/latest/org/jooq/impl/DSL.html#inline(T) Cheers Lukas 2014-04-06 9:20 GMT+02:00 Vijay Ganesan <[email protected]>: > > What is the JOOQ way of doing a union with a constant e.g. how do you > achieve the equivalent of: > select column from table *union all select (2)*; > which selects column values from table and adds a row with value 2. > > Thanks > > > -- > 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.
