postgresql 中的 with 用法

WITH delete_rows AS ( DELETE FROM company WHERE salary < 10000 RETURNING * ) INSERT INTO company1 ( SELECT * FROM delete_rows );

WITH RECURSIVE T AS (
    SELECT ID
        ,
        NAME,
        parent_id 
    FROM
        "f_department_2WIQRCZ" 
    WHERE
        ID = 2 UNION ALL
    SELECT K
        .ID,
        K.NAME,
        K.parent_id 
    FROM
        "f_department_2WIQRCZ" K,
    T 
    WHERE
        T.ID = K.parent_id 
    ) SELECT
    * 
FROM
    T;