Postgresql 使用 WHERE 子句创建递归视图

我正在try 为我的递归查询创建一个视图，并使用带有WHERE子句的视图来设置起点.

CREATE TABLE dog (
    id int,
    name varchar(50)
)

CREATE TABLE dog_parent (
    id int,
    dog_id int,
    parent_id int,
)

这个递归查询返回我所期望的结果

WITH recursive Ancestor_Tree AS (
    SELECT 
        mp.dog_id,
        mp.parent_id
    FROM
        dog_parent mp
    WHERE mp.dog_id = 26

    UNION ALL

    SELECT
        mp.dog_id,
        mp.parent_id
    FROM
        dog_parent mp,
        Ancestor_Tree ft
    WHERE mp.dog_id = ft.parent_id
)

SELECT 
    ft.dog_id,
    mm.name AS Member,
    ft.parent_id,
    mp.name AS Parent
FROM Ancestor_Tree ft
INNER JOIN dog mm
    ON mm.id = ft.dog_id
INNER JOIN dog mp
    ON mp.id = ft.parent_id

结果:

| dog_id | member     | parent_id | parent         |
| ------ | ---------- | --------- | -------------- |
| 33     | Beniga     | 35        | Bunta          |
| 33     | Beniga     | 36        | Kaori          |
| 26     | Rei        | 33        | Beniga         |
| 34     | Ginga      | 37        | Gouzanhaou     |
| 34     | Ginga      | 38        | Ukigumo        |
| 26     | Rei        | 34        | Ginga          |
| 38     | Ukigumo    | 39        | Kumotarou      |
| 38     | Ukigumo    | 40        | Gintsurugihime |
| 37     | Gouzanhaou | 41        | Gyokuhou       |
| 35     | Bunta      | 42        | Koharu         |
| 35     | Bunta      | 43        | Chouhou        |
| 43     | Chouhou    | 44        | Kotofusa       |
| 43     | Chouhou    | 45        | Tsubomi        |
| 36     | Kaori      | 46        | Chacha         |
| 46     | Chacha     | 47        | Teruhide       |
| 46     | Chacha     | 48        | Sekihoume      |
| 36     | Kaori      | 49        | Kokuga         |
| 49     | Kokuga     | 50        | Kotokaze       |
| 50     | Kotokaze   | 51        | Seizanhou      |
| 50     | Kotokaze   | 52        | Houki          |

但我想要创建一个VIEW，并用WHERE代替WHERE mp.dog_id = 26，就像这样:

SELECT * FROM recursive_view WHERE dog_id = 26

以下是我try 创建该视图的方式:

CREATE OR REPLACE VIEW recursive_view AS
WITH recursive Ancestor_Tree (dog_id, parent_id) AS (
    SELECT 
        mp.dog_id as dog_id,
        mp.parent_id as parent_id
    FROM
        dog_parent mp

    UNION ALL

    SELECT
        mp.dog_id,
        mp.parent_id
    FROM
        dog_parent mp,
        Ancestor_Tree ft
    WHERE mp.dog_id = ft.parent_id
)

SELECT 
    ft.dog_id,
    mm.name AS Member,
    ft.parent_id,
    mp.name AS Parent
FROM Ancestor_Tree ft
INNER JOIN dog mm
    ON mm.id = ft.dog_id
INNER JOIN dog mp
    ON mp.id = ft.parent_id

但当我用SELECT * FROM recursive_view WHERE dog_id = 26调用它时，我只得到狗26的父母，而不是递归部分.

结果:

| dog_id | member     | parent_id | parent         |
| ------ | ---------- | --------- | -------------- |
| 26     | Rei        | 33        | Beniga         |
| 26     | Rei        | 34        | Ginga          |

对于这个接受WHERE子句的递归查询，我如何才能得到VIEW呢？