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
|
| Список | 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 по дате отправления: