I am attempting to use the Postgres with keyword to modify multiple tables, with the results of one feeding into the other. This seems to be possible with the default Postgres syntax:
http://www.postgresql.org/docs/current/interactive/queries-with.html#QUERIES-WITH-MODIFYING WITH moved_rows AS ( DELETE FROM products WHERE "date" >= '2010-10-01' AND "date" < '2010-11-01' RETURNING * ) INSERT INTO products_log SELECT * FROM moved_rows; But it appears as the JOOQ DSL only supports SELECTs inside of a WITH. Is there any way I can coerce an insert statement to a select for the purposes of using it inside of a with? Or is there something else I can do? Thanks! Alex -- 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. For more options, visit https://groups.google.com/d/optout.
