BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /sun/TrafficCount/trunk/sql/report_per_month.sql @ 938

  → /sun/TrafficCount/trunk/sql/report_per_month.sql @ 939

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Ignore whitespace Rev 938 → Rev 939

/sun/TrafficCount/trunk/sql/report_per_month.sql
0,0 → 1,31
select (date ('2003-' || month || '-01')) as the_date,
round((
(
select base + delta from tcount
where source = 'tun0_out'
and host = 'sun'
and stamp = (
select max(stamp) from tcount
where date_trunc('month', stamp) = date_trunc('month', date ('2003-' || month || '-01'))
and source = 'tun0_out'
and host = 'sun'
)
)
-
COALESCE((
select base + delta from tcount
where source = 'tun0_out'
and host = 'sun'
and stamp = (
select max(stamp) from tcount
where date_trunc('month', stamp)
= date_trunc('month', date ('2003-' || month || '-01')) - interval '1 month'
and source = 'tun0_out'
and host = 'sun'
)
), 0)
) / 1024 / 1024)
as count
from tmonths m
order by the_date;