WITH moved_rows AS (

    DELETE FROM products

    WHERE

        "date" >= '2010-10-01' AND

        "date" < '2010-11-01'

    RETURNING *

)

INSERT INTO products_log

SELECT * FROM moved_rows;