Re: BUG #14294: Problem in generate series between dates - Mailing list pgsql-bugs

From Christoph Berg
Subject Re: BUG #14294: Problem in generate series between dates
Date
Msg-id 20160831153737.xubrne5yzfedscym@msg.df7cb.de
Whole thread Raw
In response to Re: BUG #14294: Problem in generate series between dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #14294: Problem in generate series between dates  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
Re: Tom Lane 2016-08-24 <31168.1472069440@sss.pgh.pa.us>
> In other words, we could make this scenario "work" if we defined
> generate_series as base plus N times the increment, rather than as
> repeated addition of the increment.  But I wouldn't be surprised
> if that would break other corner cases (and it would certainly
> be slower).  Daylight-savings time is not one of the more consistent
> things in our world ... not that anything at all about the civil
> calendar is mathematically nice :-(.

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

Christoph

pgsql-bugs by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: BUG #14302: SQL with LIMIT degrades performance seriously
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #14302: SQL with LIMIT degrades performance seriously