CREATE OR REPLACE FUNCTION "arr_to_table" (arr "pg_catalog"."anyarray") 
 RETURNS SETOF "pg_catalog"."anyelement" AS
$body$
declare
  i int;
  ub int;
BEGIN
ub:=array_upper(arr,1);
IF ub then
  FOR i IN 1..ub  loop 
    RETURN next arr[i];
  end loop;
end IF;
END;
$body$
LANGUAGE 'plpgsql';

 SELECT regexp_split_to_table(array_to_string(enum_range(NULL::tt_office),';'),';') AS tt_office;

CREATE TYPE myenum AS enum ('red','green','blue');
SELECT enumlabel 
   FROM pg_enum 
   WHERE enumtypid = 'myenum'::regtype 
   ORDER BY oid;
 
 enumlabel
-----------
 red
 green
 blue
(3 rows)