Hi Lukas,
On Fri, Jun 5, 2015 at 10:00 AM, Lukas Eder <[email protected]> wrote:
> In the meantime, you'll have to somehow generate a "true" predicate. Here
> are some ideas:
>
> on("true")
> on("1 = 1")
> on(DSL.trueCondition())
> on(DSL.condition(true))
Many thanks for this - I've changed the LEFT OUTER JOIN LATERAL () ON
true generation to this:
leftOuterJoin(DSL.lateral(
ctx.select().
from(ENTRY_ANNOUNCEMENTS).
join(PRE_CANNED_ANNOUNCEMENTS).
on(PRE_CANNED_ANNOUNCEMENTS.ANNOUNCEMENT_ID.eq(ENTRY_ANNOUNCEMENTS.ID)).
limit(1)
)).on(DSL.trueCondition())
Now the whole thing works perfectly :-)
Regarding the API change - from my perspective I think the API as it
is currently is pretty good for this scenario - it was just my
ignorance of how the API works. This kind of example is something you
might put into some kind of JOOQ cookbook, but of course, who has the
time to be writing this kind of thing for free?
Thanks again for your all of your help.
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.
