On Fri, Apr 18, 2008 at 8:13 AM, Peter Brawley <peter.brawley@stripped>
> > How can we manage the history of changed rows in the database.
> Point-in-time architecture. For a bit of discussion see
I have used this convention and it works well.
I have a real problem with how it suggests using NULL. NULL is undefined,
and they are basically abusing it to mean infinite positive. NULL has issues
being indexed, big datetime values don't.
At the recent postgres convention I eavesdropped on a discussion about a
possible new temporal range format which would basically consist of a start
date and an end date and preclude any other entries from overlapping. Such
a format would be ideal for PITA, but the start and end would need to be not