X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id AA09C9FA2F7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 26 Jun 2006 21:53:20 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 53692-08 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 26 Jun 2006 21:53:11 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171])
	by postgresql.org (Postfix) with ESMTP id 230749FA5FC
	for <pgsql-sql@postgresql.org>; Mon, 26 Jun 2006 21:53:10 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id a2so2332720ugf
	for <pgsql-sql@postgresql.org>; Mon, 26 Jun 2006 17:53:09 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=tX+Twctv0OIPMywQBdoEE2QHzTxyf5EEhzhKVMyBaebTjaHnKIwFVOnNbNh94jQxm/NBeIFwjN9iO8Dph10G5O2GZpTONNaLmFqBxKJEUZY0g6W3CVd1zl+rJmshIkOTPeideAMcSUHekIHKVxa883W0nfV7LA3SwpDPuUH6BBA=
Received: by 10.78.177.3 with SMTP id z3mr2335333hue;
	Mon, 26 Jun 2006 17:53:09 -0700 (PDT)
Received: by 10.78.29.2 with HTTP; Mon, 26 Jun 2006 17:53:09 -0700 (PDT)
Message-ID: <bf05e51c0606261753r68d5b2b3s1021fdc0a382614@mail.gmail.com>
Date: Mon, 26 Jun 2006 19:53:09 -0500
From: "Aaron Bono" <postgresql@aranya.com>
To: Joe <dev@freedomcircle.net>
Subject: Re: avg(interval)
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "Jeremiah Elliott" <geek00@gmail.com>,
	pgsql-sql@postgresql.org
In-Reply-To: <44A05BD4.60900@freedomcircle.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_11069_12110682.1151369589209"
References: <17eca7f50606261422m77395b89ufb713720defb8b42@mail.gmail.com>
	<23243.1151357823@sss.pgh.pa.us> <44A05BD4.60900@freedomcircle.net>
X-Google-Sender-Auth: 65a52305a404f96a
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/276
X-Sequence-Number: 25512

------=_Part_11069_12110682.1151369589209
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Right, the 23 is just less than 1 day, not 23 days.

The good news: your query is working!

-Aaron

On 6/26/06, Joe <dev@freedomcircle.net> wrote:
>
> Tom Lane wrote:
> > "Jeremiah Elliott" <geek00@gmail.com> writes:
> >> however if i don't average them here is what i get:
> >> "7 days 22:24:50.62311";"*2420"
> >> "9 days 22:21:02.683393";"*2420"
> >> "23:21:35.458459";"*2420"
> >> "4 days 22:47:41.749756";"*2420"
> >> "3 days 06:05:59.456947";"*2420"
> >
> >> which should average to just over nine days -
> >
> > Uh ... how do you arrive at that conclusion?  I haven't done the math,
> > but by eyeball an average of four-something days doesn't look out of
> > line for those values.
>
> It seems he's calculating (7 + 9 + 23 + 4 + 3) / 5 ...
>
> Joe
>
>

------=_Part_11069_12110682.1151369589209
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Right, the 23 is just less than 1 day, not 23 days.<br><br>The good news: your query is working!<br><br>-Aaron<br><br><div><span class="gmail_quote">On 6/26/06, <b class="gmail_sendername">Joe</b> &lt;<a href="mailto:dev@freedomcircle.net">
dev@freedomcircle.net</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Tom Lane wrote:<br>&gt; &quot;Jeremiah Elliott&quot; &lt;
<a href="mailto:geek00@gmail.com">geek00@gmail.com</a>&gt; writes:<br>&gt;&gt; however if i don't average them here is what i get:<br>&gt;&gt; &quot;7 days 22:24:50.62311&quot;;&quot;*2420&quot;<br>&gt;&gt; &quot;9 days 22:21:
02.683393&quot;;&quot;*2420&quot;<br>&gt;&gt; &quot;23:21:35.458459&quot;;&quot;*2420&quot;<br>&gt;&gt; &quot;4 days 22:47:41.749756&quot;;&quot;*2420&quot;<br>&gt;&gt; &quot;3 days 06:05:59.456947&quot;;&quot;*2420&quot;
<br>&gt;<br>&gt;&gt; which should average to just over nine days -<br>&gt;<br>&gt; Uh ... how do you arrive at that conclusion?&nbsp;&nbsp;I haven't done the math,<br>&gt; but by eyeball an average of four-something days doesn't look out of
<br>&gt; line for those values.<br><br>It seems he's calculating (7 + 9 + 23 + 4 + 3) / 5 ...<br><br>Joe<br><br></blockquote></div>

------=_Part_11069_12110682.1151369589209--