logoalt Hacker News

larsnystromyesterday at 6:18 PM1 replyview on HN

You could also make the price column nullable and just insert a row with price null and the date from which there should be no price.


Replies

throwaway7783yesterday at 7:29 PM

Yeah, but now this is implicit information (no price == marker row) and duplicate the entire row. And it is baking in "price" as the special field. This may not be just one field for another temporal entity