5 ms·
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.
by larsnystrom 3mo 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.
- throwaway7783 3mo agoYeah, 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