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

From Tom Lane
Subject Re: width_bucket function for timestamps
Date
Msg-id 4187.1160416177@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  ("Jim C. Nasby" <jim@nasby.net>)
List 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 by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: width_bucket function for timestamps
Next
From: Tom Lane
Date:
Subject: Re: pg_dump exclusion switches and functions/types