Re: width_bucket function for timestamps - Mailing list pgsql-hackers

From Tom Lane
Subject Re: width_bucket function for timestamps
Date
Msg-id 2608.1160409732@sss.pgh.pa.us
Whole thread Raw
In response to Re: width_bucket function for timestamps  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: width_bucket function for timestamps
Re: width_bucket function for timestamps
Re: width_bucket function for timestamps
List 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 by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: width_bucket function for timestamps
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Upgrading a database dump/restore