Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 8066647654F
	for <pgsql-sql@postgresql.org>; Tue,  3 Sep 2002 09:38:52 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id BC3E8476540
	for <pgsql-sql@postgresql.org>; Tue,  3 Sep 2002 09:38:51 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g83DbRZM005239;
	Tue, 3 Sep 2002 09:37:27 -0400 (EDT)
To: Oliver Elphick <olly@lfix.co.uk>
Cc: Doppelganger <quadratini@sni.ph>, pgsql-sql@postgresql.org
Subject: Re: convert sum (interval) to seconds 
In-reply-to: <1031051470.18322.12.camel@linda> 
References: <1031049935.25016.14.camel@tiger-work.sni.ph>
	<1031051470.18322.12.camel@linda>
Comments: In-reply-to Oliver Elphick <olly@lfix.co.uk>
	message dated "03 Sep 2002 12:11:10 +0100"
Date: Tue, 03 Sep 2002 09:37:27 -0400
Message-ID: <5238.1031060247@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/8
X-Sequence-Number: 9285

Oliver Elphick <olly@lfix.co.uk> writes:
> On Tue, 2002-09-03 at 11:45, Doppelganger wrote:
>> How can I convert sum(interval) to seconds?

> Here's one way;
    
>     junk=# select extract (minute from sum(if)) * 60 + extract (second
>     from sum(if)) from i;

EXTRACT(EPOCH FROM interval) is designed for this ...

			regards, tom lane