Re: [sqlalchemy] Usage problem with CTEs and INSERTs

2019-11-05 Thread Mike Bayer
On Tue, Nov 5, 2019, at 4:08 AM, Lele Gaifax wrote: > Hi all, > > I'm almost sure I'm missing the obvious, struggling to understand how to use a > CTE with a PG "upsert" statement: I need to modify an existing (and working as > expected) update statement based on a CTE to an upsert, because now

[sqlalchemy] Usage problem with CTEs and INSERTs

2019-11-05 Thread Lele Gaifax
Hi all, I'm almost sure I'm missing the obvious, struggling to understand how to use a CTE with a PG "upsert" statement: I need to modify an existing (and working as expected) update statement based on a CTE to an upsert, because now the target information is kept in a different table. As said,