Re: width_bucket function for timestamps

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: width_bucket function for timestamps
Дата
Msg-id 4187.1160416177@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: width_bucket function for timestamps  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: width_bucket function for timestamps  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> On Mon, Oct 09, 2006 at 12:02:12PM -0400, Tom Lane wrote:
>> ... I think Jeremy's problem would be solved just by applying
>> the float8 version to "extract(epoch from timestamp)".

Thinko there ... I meant to type "extract(epoch from interval)".

> Well, it would be nice to have a timestamp version so that users didn't
> have to keep typing "extract(epoch from timestamp)"... but yeah, I
> suspect that would work fine for timestamps. For intervals I suspect you
> could just convert to seconds (if we're going to add timestamps, it
> seems like we should add intervals as well).

This is exactly the slippery slope I don't care to start down.
        regards, tom lane


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: width_bucket function for timestamps
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump exclusion switches and functions/types