Hacker News new | ask | show | jobs
by larsnystrom 4 days ago
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.
1 comments

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