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

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема Re: BUG #14294: Problem in generate series between dates
Дата
Msg-id 20160831153737.xubrne5yzfedscym@msg.df7cb.de
обсуждение исходный текст
Ответ на Re: BUG #14294: Problem in generate series between dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #14294: Problem in generate series between dates
Список 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 по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: BUG #14302: SQL with LIMIT degrades performance seriously
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: BUG #14302: SQL with LIMIT degrades performance seriously