or am I mis-using the alias in the insert statement
Probandset a = PROBANDSET.as("a");
ctx.insertInto(PROBANDSET_GROUP_MEMBER,
PROBANDSET_GROUP_MEMBER.GROUP_ID,
PROBANDSET_GROUP_MEMBER.MEMBER_ID)
.select(ctx.select(inline(pbsgRec.getId()), a.PROBANDSET.ID)
.from(a)
.where((inline(supersetIds).contains(a.PROBANDS))
.and(a.PEOPLE_ID.eq(peepRec.getId()))))
.execute();
yields
insert into "probandset_group_member" ("group_id", "member_id")
select '83a696be-b2c6-489e-9a5f-9fa1e1a4fa6a', "probandset"."id"
from "probandset" as "a" where (null @> "a"."probands" and "a"."people_id"
= '3ab7f9f9-7114-401f-a11b-99124538e6a7')
with error message from postgres 10.5
; ERROR: invalid reference to FROM-clause entry for table "probandset"
Hint: Perhaps you meant to reference the table alias "a".
Position: 112
I'll worry about the "null" value later...
--
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.
