spacepaste

  1.  
  2. alexander=> SELECT * FROM test;
  3. path | removed_time
  4. -----------------------------------------------+----------------------------
  5. Top |
  6. Top.Science |
  7. Top.Science.Astronomy.Astrophysics |
  8. Top.Science.Astronomy.Cosmology |
  9. Top.Hobbies |
  10. Top.Hobbies.Amateurs_Astronomy |
  11. Top.Collections |
  12. Top.Collections.Pictures |
  13. Top.Collections.Pictures.Astronomy.Stars |
  14. Top.Collections.Pictures.Astronomy.Galaxies |
  15. Top.Collections.Pictures.Astronomy.Astronauts |
  16. Top.Science.Astronomy | 2018-04-17 11:27:36.050116
  17. Top.Collections.Pictures.Astronomy | 2018-04-18 06:40:00.79992
  18. (13 строк)
  19. alexander=> SELECT * FROM test
  20. WHERE NOT path @> (SELECT array_agg(path) FROM test WHERE removed_time IS NOT NULL);
  21. path | removed_time
  22. -----------------------------------------------+--------------
  23. Top.Science.Astronomy.Astrophysics |
  24. Top.Science.Astronomy.Cosmology |
  25. Top.Hobbies |
  26. Top.Hobbies.Amateurs_Astronomy |
  27. Top.Collections.Pictures.Astronomy.Stars |
  28. Top.Collections.Pictures.Astronomy.Galaxies |
  29. Top.Collections.Pictures.Astronomy.Astronauts |
  30. (7 строк)
  31. alexander=> SELECT * FROM test
  32. WHERE path NOT IN (SELECT path FROM test WHERE removed_time IS NOT NULL);
  33. path | removed_time
  34. -----------------------------------------------+--------------
  35. Top |
  36. Top.Science |
  37. Top.Science.Astronomy.Astrophysics |
  38. Top.Science.Astronomy.Cosmology |
  39. Top.Hobbies |
  40. Top.Hobbies.Amateurs_Astronomy |
  41. Top.Collections |
  42. Top.Collections.Pictures |
  43. Top.Collections.Pictures.Astronomy.Stars |
  44. Top.Collections.Pictures.Astronomy.Galaxies |
  45. Top.Collections.Pictures.Astronomy.Astronauts |
  46. (11 строк)
  47.