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
------+-------
5415 | 12532
(1 row)
transatlantic=# select min(id),max(id) from stats where timesliced<'01-May-2001';
min | max
-----+------
10 | 2345
(1 row)
Cheers,
Patrick