Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2014
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. SELECT tstzrange('-infinity','infinity') && tstzrange(NULL, NULL);
  2. ?column?
  3. ----------
  4. t
  5.  
  6. SELECT tstzrange('2013-01-01 00:00:00+01', '2013-02-01 00:00:00+01')
  7. && tstzrange(NULL, '2013-03-01 00:00:00+01');
  8. ?column?
  9. ----------
  10. t
  11.  
  12. SELECT tstzrange('2013-01-01 00:00:00+01', '2013-02-01 00:00:00+01')
  13. && tstzrange('-infinity', '2013-03-01 00:00:00+01');
  14. ?column?
  15. ----------
  16. t
  17.  
  18. SELECT tstzrange('-infinity','infinity') = tstzrange(NULL, NULL);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement