Re: create view problem

> 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...