> Hi > I want to store dates / events for example birthdays (or may 5th) that > repeats every year.. > what is the best way to do in postgres? > if i use timestamp it is going to be use the current year.. how do i do > this?
Along with the timestamp store a boolean that indicates if the event should consider the year or not.
But you might surely design it better, specially for things that repeat on intervals other than yearly.
yes i am trying to build a alerting system where events will repeat weekly/monthly/annually
what is the best way to store this kind of information in postgres? thanks