News for hackers. Stuff that matters.
Re:Lesser-known Postgres features by KarlKemp on Tuesday November 09, 2021 @05:13PM (#29168220)
I believe it's about the common case of two events sharing a single (infinitely small) point of time: meeting A from 3 to 4, followed by meeting B from 4 to 5.

Those two time periods do overlap mathematically, but not physically: they share the common point of "4", even if that point has duration 0.

I know the iCal standard goes into this for a bit.

Re:Lesser-known Postgres features by zeroimpl on Tuesday November 09, 2021 @09:09PM (#29170311)
Don’t you just treat the range as half-open? Eg a '[)' range in Postgres.