Re: avg(interval)
| От | Joe |
|---|---|
| Тема | Re: avg(interval) |
| Дата | |
| Msg-id | 44A05BD4.60900@freedomcircle.net обсуждение исходный текст |
| Ответ на | Re: avg(interval) (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: avg(interval)
|
| Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: