2 ms·
You can, like this: WITH results as ( SELECT ... ), inserted_rows AS ( INSERT ... SELECT * FROM results ... ), de
by nicoburns 4y ago
You can, like this:
WITH results as (
SELECT ...
),
inserted_rows AS (
INSERT ...
SELECT * FROM results
...
),
deleted_rows AS (
DELETE ...
USING results
...
)
UPDATE ...
FROM results
- gen220 4y agoWoah! I stand corrected, thanks. It seems you’re knowledgeable on this, do you know if MERGE useful beyond expressivity?