On Fri, 4 Jan 2019, Jeremy Finzel wrote:
Another suggestion which hasn’t been mentioned is using ‘infinity’ as the end date. I like this because it IMO indicates that the record is clearly the current valid record more than null.
Jeremy, I believe that infinity was mentioned in this thread.
But I’m not sure exactly what you are trying to do either. If you are creating a new record with changes and closing (ending) the range of the original record, then a GIST exclusion index would ensure you have no overlapping date ranges for all historical records put together.
Having overlapping date ranges in a projects table is a Good Thing(TM) because it means I have multiple, concurrent revenue streams. :-) Carpe weekend, Rich -- I dream of an America where a chicken can cross the road without having its motives questioned.
