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.
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 |