Perhaps a more addressable problem statement: referring to a previous CTE
(
select distinct unnest(c.loci_ordinals) as ord
from cliqueset c -- CTE referenced here
where 12994 < any(c.loci_ordinals) or 12849 > any(c.loci_ordinals)
)
In jOOQ I had to bring in the actual table containing the array
Field<Integer> lowOrd = DSL.val(pterIndex);
Field<Integer> highOrd = DSL.val(qterIndex);
CommonTableExpression<Record1<Integer>> extras =
name("xm").fields("xord")
.as(selectDistinct(cliqueset.field("mord").cast(Integer.class).as("xord"))
.from(cliqueset.join(LD_CLIQUE).on(cliqueset.field("qid").cast(UUID.class).eq(LD_CLIQUE.MARKERSET_ID)
.and(cliqueset.field("qord").cast(Integer.class).eq(LD_CLIQUE.ORDINAL))))
.where(lowOrd.gt(DSL.any(LD_CLIQUE.LOCI_ORDINALS)))
.or(highOrd.lt(DSL.any(LD_CLIQUE.LOCI_ORDINALS))));
On 3/5/21 10:06 AM, Rob Sargent wrote:
I'm sure you've given up by now but the orderBy() needs to be on the
union of course not the second CTE
rjs
On 3/5/21 8:25 AM, Rob Sargent wrote:
Sorry, the error is
.from(extras).join(MARKERSET_MEMBER).on(extras.field("xord") ==
(MARKERSET_MEMBER.ORDINAL))
java equals operator silently kills it
On 3/5/21 7:58 AM, Rob Sargent wrote:
Scrap that example.
on(cliqueset.field("qid").cast(UUID.class).eq(LD_CLIQUE.MARKERSET_ID)
become "on false"
so I have more work to do.
On 3/5/21 1:04 AM, Lukas Eder wrote:
We don't have any, though we probably should (especially for CTE,
there's a pending issue for that). What are you looking for,
specifically?
On Thu, Mar 4, 2021 at 10:40 PM Rob Sargent <robjsarg...@gmail.com
<mailto:robjsarg...@gmail.com>> wrote:
Is there a repository of more complex examples of jOOQ code?
I'm having
a lot of fun with CTEs and DSL.any and I think I'm conforming
to the
website examples.
--
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+unsubscr...@googlegroups.com
<mailto:jooq-user%2bunsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/0c174979-b542-eca3-44cb-adc47ade1310%40gmail.com
<https://groups.google.com/d/msgid/jooq-user/0c174979-b542-eca3-44cb-adc47ade1310%40gmail.com>.
--
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+unsubscr...@googlegroups.com
<mailto:jooq-user+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/CAB4ELO7FRKpTKcKXEGfaB533G0XmmARuSuFNkoVNgbANCP5aqg%40mail.gmail.com
<https://groups.google.com/d/msgid/jooq-user/CAB4ELO7FRKpTKcKXEGfaB533G0XmmARuSuFNkoVNgbANCP5aqg%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/7a23d1dd-af96-17da-955b-7f3adc9b9fa9%40gmail.com.
