The CTE is bound to the currently executing query. It takes the ids that
need otherwise would be in a temporary table and feeds them using the
VALUES() expression.
It's interesting the reason for doing so: "reducing concurrency on system
tables every time Postgresql creates temp tables".
I'd have t
How does one reference a CTE across multiple deletes via JDBC? A CTE, by
definition, is available only during the execution of a single query. In
most databases you "work around" that by grouping statements into a block
(GO, BEGIN/END etc). This is what JDBC poorly attempt to mimic with
Prepared
