PostgreSQL: search a top-level root parent id

search.sql

with recursive r as (
  select id, parent_id
    from products
   where id = 100
  union
  select p.id, p.parent_id
    from products p
    join r on p.id = r.parent_id
)
select id from r where parent_id is null;