alexander=> SELECT * FROM test;
                     path                      |        removed_time
-----------------------------------------------+----------------------------
 Top                                           |
 Top.Science                                   |
 Top.Science.Astronomy.Astrophysics            |
 Top.Science.Astronomy.Cosmology               |
 Top.Hobbies                                   |
 Top.Hobbies.Amateurs_Astronomy                |
 Top.Collections                               |
 Top.Collections.Pictures                      |
 Top.Collections.Pictures.Astronomy.Stars      |
 Top.Collections.Pictures.Astronomy.Galaxies   |
 Top.Collections.Pictures.Astronomy.Astronauts |
 Top.Science.Astronomy                         | 2018-04-17 11:27:36.050116
 Top.Collections.Pictures.Astronomy            | 2018-04-18 06:40:00.79992
(13 строк)

alexander=> SELECT * FROM test
WHERE NOT path @> (SELECT array_agg(path) FROM test WHERE removed_time IS NOT NULL);
                     path                      | removed_time
-----------------------------------------------+--------------
 Top.Science.Astronomy.Astrophysics            |
 Top.Science.Astronomy.Cosmology               |
 Top.Hobbies                                   |
 Top.Hobbies.Amateurs_Astronomy                |
 Top.Collections.Pictures.Astronomy.Stars      |
 Top.Collections.Pictures.Astronomy.Galaxies   |
 Top.Collections.Pictures.Astronomy.Astronauts |
(7 строк)

alexander=> SELECT * FROM test
WHERE path NOT IN (SELECT path FROM test WHERE removed_time IS NOT NULL);
                     path                      | removed_time
-----------------------------------------------+--------------
 Top                                           |
 Top.Science                                   |
 Top.Science.Astronomy.Astrophysics            |
 Top.Science.Astronomy.Cosmology               |
 Top.Hobbies                                   |
 Top.Hobbies.Amateurs_Astronomy                |
 Top.Collections                               |
 Top.Collections.Pictures                      |
 Top.Collections.Pictures.Astronomy.Stars      |
 Top.Collections.Pictures.Astronomy.Galaxies   |
 Top.Collections.Pictures.Astronomy.Astronauts |
(11 строк)