:37 AM
To: Jeff Adams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Date Range Using Months and Days Only
On Thu, Oct 20, 2011 at 8:42 AM, Jeff Adams wrote:
Thanks for the reply and assistance. I share your concern that the approach
may be slow. I am not adverse to creating some
[mailto:adam.corn...@gmail.com]
Sent: Wednesday, October 19, 2011 6:51 PM
To: Jeff Adams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Date Range Using Months and Days Only
On Wed, Oct 19, 2011 at 12:40 PM, Jeff Adams wrote:
Greetings,
I have to write a query on a fairly large table of data (>
over 0 would indicate that
> the date does fall within the range?
>
> From: Adam Cornett [mailto:adam.corn...@gmail.com]
> Sent: Wednesday, October 19, 2011 6:51 PM
> To: Jeff Adams
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Date Range Using Months and Days O
On Wed, Oct 19, 2011 at 12:40 PM, Jeff Adams wrote:
> Greetings,
>
> I have to write a query on a fairly large table of data (>100 million rows)
> where I need to check to see if a date (epoch) falls between a range of
> values. The catch is that the range is defined only by month and day
> value
Greetings,
I have to write a query on a fairly large table of data (>100 million rows)
where I need to check to see if a date (epoch) falls between a range of
values. The catch is that the range is defined only by month and day values.
For example the record containing the epoch value will be link
