Re: width_bucket function for timestamps

Поиск
Список
Период
Сортировка
"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