On Wed, Sep 19, 2001 at 11:34:56AM -0700, Stephan Szabo wrote:
>
> Are there no rows with timesliced<'01-May-2001'? I think in that
> case sum() gives you one row with NULL.
Thank you for the clue! *slaps forehead*
transatlantic=# select min(stats_id),max(stats_id) from trans;
min | max
-
On Wed, 19 Sep 2001, Patrick Welche wrote:
> select coalesce(sum(deltafromoctets),0)
> from trans,stats
> where stats_id=stats.id
>and (timeslicet < '1:05' OR timeslicet > '6:05')
>
> returns a number (9188191930), whereas
>
> select coalesce(sum(deltafromoctets),0)
> from trans,stats
select coalesce(sum(deltafromoctets),0)
from trans,stats
where stats_id=stats.id
and (timeslicet < '1:05' OR timeslicet > '6:05')
returns a number (9188191930), whereas
select coalesce(sum(deltafromoctets),0)
from trans,stats
where stats_id=stats.id
and (timeslicet < '1:05' OR timesl