| ▲ | larsnystrom 6 hours 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 4 hours ago | parent [-] | |
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 | ||