union with constant

[Vijay Ganesan]

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

[Lukas Eder]

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

--
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/d/optout.