Re: Multitable insert syntax support on Postgres?

>
> WITH data_src AS (SELECT * FROM source_tbl),
> insert_a AS (INSERT INTO a SELECT * FROM data_src WHERE d < 5),
> insert_b AS (INSERT INTO b SELECT * FROM data_src WHERE d >= 5)
> INSERT INTO c SELECT * FROM data_src WHERE d < 5
>

I suppose you could just do a dummy SELECT at the bottom to make it look
more symmetrical

WITH data_src AS (SELECT * FROM source_tbl),
insert_a AS (INSERT INTO a SELECT * FROM data_src WHERE d < 5),
insert_b AS (INSERT INTO b SELECT * FROM data_src WHERE d >= 5)
insert_c AS (INSERT INTO c SELECT * FROM data_src WHERE d < 5)
SELECT true AS inserts_complete;

Or maybe get some diagnostics out of it:

WITH data_src AS (SELECT * FROM source_tbl),
insert_a AS (INSERT INTO a SELECT * FROM data_src WHERE d < 5 RETURNING
NULL),
insert_b AS (INSERT INTO b SELECT * FROM data_src WHERE d >= 5 RETURNING
NULL),
insert_c AS (INSERT INTO c SELECT * FROM data_src WHERE d < 5 RETURNING
NULL)
SELECT
(SELECT COUNT(*) FROM insert_a) AS new_a_rows,
(SELECT COUNT(*) FROM insert_b) AS new_b_rows,
(SELECT COUNT(*) FROM insert_c) AS new_c_rows;