On Mon, Nov 24, 2014 at 8:28 AM, Lukas Eder <[email protected]> wrote: > OK, so that's clear now. However, you currently can't use that syntax in > jOOQ. jOOQ cannot reason about DSL.field("x") being really a row with its > nested columns.
Good to know. > As you can see, the function call really returns an org.jooq.Table instance > with column references that you can use. This is now supported for SQL > Server (jOOQ 3.3), PostgreSQL (jOOQ 3.5), and Firebird (jOOQ 3.5). > > Let me know if you want to go further into writing this query with jOOQ That's a very cool construct. Unfortunately I've just learned today that the underlying business driver behind this "database as a queue" solution has evaporated, so I'm going to have to put this example into my JOOQ toolbox, ready for the next SQL battle. Cheers, Ben -- 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.
