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

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема Re: BUG #14294: Problem in generate series between dates
Дата
Msg-id CAEZATCW_MMOhUYV_yjOm-RZ4wcCfYAwmcUvN=k096Vq57=dqpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #14294: Problem in generate series between dates  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: BUG #14294: Problem in generate series between dates
Список pgsql-bugs
On 1 September 2016 at 00:39, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
>>>>>> "Dean" == Dean Rasheed <dean.a.rasheed@gmail.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...
>

Hmm, maybe, but since this is timezone-dependent, the existing code
might be perfectly safe in the user's part of the world. I don't
really have a feel for how likely this is to break people's code, but
I think it's something we have to consider.

Regards,
Dean

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

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