CREATE TYPE employee AS
  (   
   name text,
   age numeric,
   position text, 
   salary numeric 
   );

  CREATE TABLE departments(
    id numeric,
    depname text,   
    employes employee[]
   );

   INSERT INTO departments VALUES( 34 , 'Information Systems Developmet Group', 
   ARRAY[('Arcadiy Pereguda',  29 , 'Scientist',  15000 )::employee,
         ('Alexandr Pushkin',  59 , 'Project Manager',  30000 )::employee,  
         ('Kurt Cobain',  29 , 'Team Lead',  10000 )::employee,  
         ('Andrey Knyazev',  27 , 'Programmer',  7000 )::employee,  
         ('Stepan Ivanov',  26 , 'DBA',  10000 )::employee  
   ]);

 SELECT id, depname, employes[ 3 ].name, employes[ 3 ].age, employes[ 3 ].position, employes[ 3 ].salary FROM departments WHERE id= 34 ;