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 5CAA09FABE7 for ; Mon, 26 Jun 2006 23:49:45 -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 80288-03 for ; Mon, 26 Jun 2006 23:49:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from myemma.com (db1.e2ma.net [66.179.147.163]) by postgresql.org (Postfix) with ESMTP id DC12E9FA2F7 for ; Mon, 26 Jun 2006 23:49:34 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by myemma.com (Postfix) with ESMTP id 6AC7123CDC; Mon, 26 Jun 2006 22:29:02 -0500 (CDT) Received: from myemma.com ([127.0.0.1]) by localhost (velma [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27552-10; Mon, 26 Jun 2006 22:29:02 -0500 (CDT) Received: from [192.168.2.14] (c-68-53-113-70.hsd1.tn.comcast.net [68.53.113.70]) by myemma.com (Postfix) with ESMTP id D35B023CDA; Mon, 26 Jun 2006 22:29:01 -0500 (CDT) Message-ID: <44A09CB6.8080102@myemma.com> Date: Mon, 26 Jun 2006 21:49:26 -0500 From: Erik Jones User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Aaron Bono Cc: Joe , Tom Lane , Jeremiah Elliott , pgsql-sql@postgresql.org Subject: Re: avg(interval) References: <17eca7f50606261422m77395b89ufb713720defb8b42@mail.gmail.com> <23243.1151357823@sss.pgh.pa.us> <44A05BD4.60900@freedomcircle.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at myemma.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/279 X-Sequence-Number: 25515 Well, the query is working ok numerically, but should the answer really be reported as 4 days and 33 hours? Erik Aaron Bono wrote: > 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 > -- erik jones software development emma(r)