Stored Procedure Question

Hi All,

I wanted to create a store procedure (unless there is a easier way) so
that i get a person's next birthday date given their birthday.

Aka, in one of my queries i am trying to do:


psql> update users set next_birthday=get_next_birthday(dob) where user_id='42';

except, i don't quite know how to go about creating the get_next_birthday function.
'dob' is a field in users that is of type 'date'.

I have tried the following method:

psql> update users set next_birthday=dob + (date_part('year', timestamp 'now') - date_part('year', dob))*365.25;

Which works wonderfully, except when when i if the date of birth is say '1973-01-10' - in this case, it will put
the next_birthday as 2003-01-10 as it always converts the year to the current year, not realising that the date/month
have already passed for this year.

Any help would be appreciated,

kind regards,

simran.