Recursive breadcrumb query for Postgres

gistfile1.sql

with recursive breadcrumbs(id, parent_id, name) as (
  select id, parent_id, name
  from pages
  where id = 4
  union
  select p.id, p.parent_id, p.name
  from pages p
  inner join breadcrumbs b on p.id = b.parent_id
)
select * from breadcrumbs;