I wanted to fetch employee manager and all it's manger ids. I've tried using connectby:

select user_id  from hr_employee e   inner join resource_resource r on r.id = e.resource_id where e.id in  (  SELECT id FROM connectby('hr_employee', 'parent_id', 'id', 'id', 1, 0) AS t(id text, parent_id text, name text, name text)  WHERE parent_id is not null  )

but throwing error:

ERROR:  function connectby(unknown, unknown, unknown, unknown, integer, integer) does not existSELECT id FROM connectby('hr...

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Thanks!