Does PostgreSQL have a pseudo-column like "LEVEL" in Oracle - Mailing list pgsql-sql

begin;
create temp table tempemp  (employee_id integer primary key, last_name text,manager_id integer);
insert into tempemp values(1,'eliane',1);
insert into tempemp values(2,'sponge',1);
insert into tempemp values(3,'george',1);
insert into tempemp values(4,'kramer',2);
insert into tempemp values(5,'megan',2);
insert into tempemp values(6,'donald',3);
commit;

WITH RECURSIVE cte AS (
   SELECT employee_id, last_name, manager_id, 1 AS level
   FROM   tempemp

   UNION  ALL
   SELECT e.employee_id, e.last_name, e.manager_id, c.level + 1
   FROM   cte c
   JOIN   tempemp e ON e.manager_id = c.employee_id
   )
SELECT *
FROM   cte;