Re: One more question about intervals

In <Pine.LNX.4.30.0111041143020.19169-100000@commandprompt.com> pgsql-general@commandprompt.com ("Command Prompt,
Inc.")writes: 

>On Sun, 4 Nov 2001, Konstantinos Agouros wrote:
>in the largest units possible first, with each unit's field being a
>discrete value; it looks like the EPOCH field is the only one guaranteed
>to give you a combined length of time for the entire duration of the
>interval, so you're definitely on the right track with that.

>You could create a function like this to make your life a little easier:

>CREATE FUNCTION get_hours (interval)
>       RETURNS int4
>       AS 'SELECT round(extract(EPOCH FROM $1) / 3600.0)::integer'
>       LANGUAGE 'sql';

>Depending on whether or not you wanted to round up, down, or to the
>nearest hour, you'd use ceil(), floor(), or round() respectively, on the
>result of the division.
extract epoch from was what I needed to get this where I can work with it.
A time-formatter will come later \:)

Thanks,

Konstantin

>Then you'd just have to do:

>lx=# SELECT get_hours(sum(i)) * 100 || ' Euros' AS cost
>lx-#        FROM my_intervals;
>    cost
>------------
> 7500 Euros
>(1 row)


>Regards,
>Jw.
>--
>jlx@commandprompt.com
>by way of pgsql-general@commandprompt.com



>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres