How to make a recursive query returning all passed elements?

Question

PostgreSQL

There is a table with fields name, from_id, to_id. How to make a query at the input of which comes from_id and recursively go through the entire table and collect all to_id including for all child elements?

Answer 1

with recursive q as (
    select * from tes where from_id = 1
     union all
    select tes.* from tes, q where tes.from_id = q.to_id
)
select * from q order by from_id, to_id

https://www.db-fiddle.com/f/4jyoMCicNSZpjMt4jFYoz5/4445