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