Re: null answer - how?

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