> I wanted to add some test on time, so I did a
> CREATE VIEW
> trafic_day
> AS
> SELECT
> stats.ip,
> date(stats."time") AS date,
> count(*) AS nb,
> sum(stats.packet) AS packet,
> sum(stats.traffic) AS traffic
> FROM
> stats
> WHERE
> time::date < 'now'::date
> GROUP BY
> stats.ip,
> date(stats."time")
> ORDER BY
> sum(stats.traffic) DESC;
'Now' is evaluated at creation time. A special hack exists if it is set as
a default column value to evaluate it at insert time. Change it to this:
CREATE VIEWtrafic_day
ASSELECT stats.ip, date(stats."time") AS date, count(*) AS nb, sum(stats.packet) AS packet, sum(stats.traffic) AS
trafficFROMstatsWHERE time::date < CURRENT_DATEGROUP BY stats.ip, date(stats."time")ORDER BY sum(stats.traffic) DESC;
You don't even need the 'time::date' bit - just use 'time'.
Cheers,
Chris
ps. You spelled 'traffic' as 'trafic' above...