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

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Christoph Berg <myon(at)debian(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pablopumarino(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14294: Problem in generate series between dates
Date: 2016-08-31 19:48:22
Message-ID: 87d1ko4t69.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Christoph" == Christoph Berg <myon(at)debian(dot)org> writes:

Christoph> To avoid DST problems, wouldn't a "date"-based
Christoph> generate_series be the safe way to go?

The lack of generate_series(date,date,integer) is sometimes annoying,
even though it can be worked around using the timestamp-without-timezone
variant of generate_series.

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-08-31 21:33:24 Re: BUG #14294: Problem in generate series between dates
Previous Message Andrew Gierth 2016-08-31 17:41:06 Re: BUG #14302: SQL with LIMIT degrades performance seriously