Re: Re: Add generate_series(date,date) and generate_series(date,date,integer)

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: Re: Add generate_series(date,date) and generate_series(date,date,integer)
Дата
Msg-id 56EAE7D1.2040402@pgmasters.net
обсуждение исходный текст
Ответ на Re: Re: Add generate_series(date,date) and generate_series(date,date,integer)  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 3/17/16 1:17 PM, Robert Haas wrote:
> On Thu, Mar 17, 2016 at 12:59 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> One idea that might be worth considering is to define the function
>> as generate_series(date,date,interval) returns timestamp (without
>> time zone).  The point here would be only to move the behavior for
>> date inputs as far as getting timestamp without tz rather than
>> timestamp with tz; which would at least save some timezone rotations
>> in typical use, as well as rather debatable semantics.  (The fact
>> that timestamptz is the preferred type in this hierarchy isn't
>> really doing us any favors here.)
> 
> That's a fairly tenuous benefit, though, and a substantially different
> patch.  I think it's time to give up here and move on.  We can revisit
> this for another release after we've had more time to think about it,
> if that seems like a smart thing to do when the time comes.

This has been marked "returned with feedback".

-- 
-David
david@pgmasters.net



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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: POC, WIP: OR-clause support for indexes
Следующее
От: Andres Freund
Дата:
Сообщение: Re: fd.c: flush data problems on osx