I'm trying to build the following query in the DSL:
SELECT id
FROM (
INSERT INTO foo(natural_key)
VALUES ('aKey')
ON CONFLICT DO NOTHING
RETURNING id
) ins
WHERE id IS NOT NULL
UNION DISTINCT
SELECT id
FROM foo
WHERE natural_key = 'aKey';
I'm having trouble getting a TableLike object out of the insert, with or
without the ON CONFLICT. Is this doable?
--
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.
