recursive_links.sql

	with RECURSIVE childs as (
		(
			select n.id as parent_id, l.child_id from _n  n, _l l where n.id = 2 and n.id = l.parent_id
		)
		union all
		(
			select l.parent_id, l.child_id from _d c, _l l
			where l.parent_id = c.child_id
		)
	)
	select * from childs;