Re: [PERFORM] Fastest way / best practice to calculate next birthdays

2015-05-20 Thread er.tejaspate...@gmail.com
If I have to find upcoming birthdays in current week and the current week fall into different months - how would you handle that? -- View this message in context: http://postgresql.nabble.com/Fastest-way-best-practice-to-calculate-next-birthdays-tp2068398p5849705.html Sent from the

Re: [PERFORM] Fastest way / best practice to calculate next birthdays

2015-05-20 Thread David G. Johnston
On Monday, May 18, 2015, er.tejaspate...@gmail.com er.tejaspate...@gmail.com wrote: If I have to find upcoming birthdays in current week and the current week fall into different months - how would you handle that? Extract(week from timestamptz_column) ISO weeks are not affected by month