One little comment.
On Fri, May 14, 2021 at 5:33 PM Pól Ua Laoínecháin wrote:
> I was trying to do this:
> DELETE FROM t
> WHERE id IN
> INSERT INTO t_archiv
> (
> SELECT *
> FROM t
> WHERE EXTRACT(EPOCH FROM NOW()) - epok > 15613200
> )
> RETURNING id;
...
The complex
On Fri, May 14, 2021 at 8:33 AM Pól Ua Laoínecháin wrote:
>
> I was able to do it by chaining CTEs - but I wanted to be sure that
> when chaining CTEs, all work done in a statement with multiple
> modifications to data was done within the same transaction - this is
> what I thought my SQL would
=?UTF-8?B?UMOzbCBVYSBMYW/DrW5lY2jDoWlu?= writes:
> I was trying to do this:
> DELETE FROM t
> WHERE id IN
> INSERT INTO t_archiv
> (
> SELECT *
> FROM t
> WHERE EXTRACT(EPOCH FROM NOW()) - epok > 15613200
> )
> RETURNING id;
Try putting the INSERT ... RETURNING in a CTE
Hi all,
I was trying to do this:
DELETE FROM t
WHERE id IN
INSERT INTO t_archiv
(
SELECT *
FROM t
WHERE EXTRACT(EPOCH FROM NOW()) - epok > 15613200
)
RETURNING id;
see the fiddle here:
https://dbfiddle.uk/?rdbms=postgres_12=d3cb601af2e4c99a32c56df03f97a5f2
This works,