"Jim C. Nasby" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org