PostgreSQL UPDATE table and get ids from UPDATED rows then INSERT INTO another table

postgres-update-and-insert-into-with-returning.sql

/*
PostgreSQL
If you want to insert any column retaled with update query you can use this.
It gets ids from updated tables and then inter them into another table.
*/

with rows AS (
	UPDATE  product SET price = price * 1.10
	RETURNING id
)
INSERT INTO updated_product
SELECT * FROM rows;