> That would be the decision to make - does your toolkit support (or can be > made to support) the type and are you willing to choose a sub-optimal > database model because one or more applications happen to do things > differently? > > IMO the daterange datatype is the best type you can choose for the model; > now you have to figure out and decide where any tradeoffs are and if they > are worth it given your specific circumstances.
David,
Thanks for the insights.
Regards,
Rich
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.
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.