This is still far from obvious to me. The bit that is obvious is the bit that’s written in the book. The bit that isn’t obvious (the actual INSERT code) is omitted.
It’s not obvious because the topic of RULES isn’t clearly explained, and because from what I can see the rule/view doesn’t have anything set for end date.
title maps to NEW.name starts maps to NEW.date
… and the holidays VIEW doesn’t have an end set at all.
I don’t know what I’m doing here because it’s still not clear to me how these things map together and the useful bit that’d be an example for future reference is the one bit that’s been left out of the book…