BUG #14294: Problem in generate series between dates

From: pablopumarino(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14294: Problem in generate series between dates
Date: 2016-08-24 18:29:20
Message-ID: 20160824182920.15681.52285@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14294
Logged by: Pablo Pumarino
Email address: pablopumarino(at)gmail(dot)com
PostgreSQL version: 9.5.4
Operating system: 4.4.0-34-generic #53-Ubuntu
Description:

When I use postgres function:

SELECT generate_series('2016-08-01', '2016-08-31', '1
day'::interval)::date

it gives me the corresponding list of days but for some reason it misses the
day 2016-08-31.
-I've tried this with other months and it works correctly, also if I use it
for the same dates but on 2015 it works fine.
-This started failing after we upgraded our system to the version 9.5.4,
I've tryed it in an older release that we had installed and it worked.

Best regards.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2016-08-24 18:39:07 Re: BUG #14294: Problem in generate series between dates
Previous Message Rick Otten 2016-08-24 18:21:43 Re: BUG #14290: materialized view refresh doesn't use temp_tablespace