Em Saturday 06 September 2008 14:12:49 rkmr.em@xxxxxxxxx escreveu: > 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. -- Jorge Godoy <jgodoy@xxxxxxxxx>
Attachment:
signature.asc
Description: This is a digitally signed message part.