Re: width_bucket function for timestamps

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: width_bucket function for timestamps
Дата
Msg-id 2608.1160409732@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>)
Re: width_bucket function for timestamps  (Jeremy Drake <pgsql@jdrake.com>)
Re: width_bucket function for timestamps  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> Sinte we already have width_bucket, I'd argue this should go in core. If
> someone's feeling adventurous, there should probably be a double
> precision version as well. Hrm... and maybe text...

It's not clear to me why we have width_bucket operating on numeric and
not float8 --- that seems like an oversight, if not outright
misunderstanding of the type hierarchy.  But if we had the float8
version, I think Jeremy's problem would be solved just by applying
the float8 version to "extract(epoch from timestamp)".  I don't really
see the use-case for putting N versions of the function in there.
        regards, tom lane


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: width_bucket function for timestamps
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Upgrading a database dump/restore