Re: BUG #14294: Problem in generate series between dates

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Christoph Berg <myon(at)debian(dot)org>, Pablo Pumarino Delgado <pablopumarino(at)gmail(dot)com>, "pgsql-bugs\(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14294: Problem in generate series between dates
Date: 2016-08-31 23:39:09
Message-ID: 874m604ih2.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Dean" == Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> writes:

>> Perhaps adding generate_series(date,date,interval) might work.

Dean> On second thoughts, that would change the return type of some
Dean> existing queries, which would be problematic.

But as this bug report is showing, those existing queries are at best
fragile and at worst silently wrong...

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dean Rasheed 2016-09-01 09:39:26 Re: BUG #14294: Problem in generate series between dates
Previous Message Dean Rasheed 2016-08-31 23:36:25 Re: BUG #14294: Problem in generate series between dates