Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. layer int
  2. period tstzrange
  3.  
  4. select *
  5. from t as t1
  6. where not exists
  7. (
  8. select 1
  9. from t as t2
  10. where t2.layer < t1.layer and
  11. t2.period && t1.period
  12. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement