Postgres Pro
Downloads
Home   >   mailing lists

Re: Fastest way / best practice to calculate "next birthdays" - Mailing list pgsql-performance

From David G. Johnston
Subject Re: Fastest way / best practice to calculate "next birthdays"
Date
Msg-id CAKFQuwZLcWw6=T6GU9rF+6DCN6+DSOgZJg1JAgOKLWG6KEUiWA@mail.gmail.com
Whole thread Raw
In response to Re: Fastest way / best practice to calculate "next birthdays"  ("er.tejaspatel88@gmail.com" <er.tejaspatel88@gmail.com>)
Responses Re: Fastest way / best practice to calculate "next birthdays"  (Bosco Rama <postgres@boscorama.com>)
List pgsql-performance
Tree view
On Monday, May 18, 2015, er.tejaspatel88@gmail.com <er.tejaspatel88@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 boundaries but do start on Monday.

David J.

pgsql-performance by date:

Previous
From: "er.tejaspatel88@gmail.com"
Date:
Subject: Re: Fastest way / best practice to calculate "next birthdays"
Next
From: Florian Lohoff
Date:
Subject: union all and filter / index scan -> seq scan