-
- 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 строк)
-