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

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: BUG #14294: Problem in generate series between dates
Дата
Msg-id 87d1ko4t69.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: BUG #14294: Problem in generate series between dates  (Christoph Berg <myon@debian.org>)
Ответы Re: BUG #14294: Problem in generate series between dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
>>>>> "Christoph" == Christoph Berg <myon@debian.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)

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: BUG #14302: SQL with LIMIT degrades performance seriously
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14294: Problem in generate series between dates