| From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: null answer - how? |
| Date: | 2001-09-20 10:43:49 |
| Message-ID: | 20010920114349.A1276@quartz.newn.cam.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christof Petig | 2001-09-20 10:46:13 | Re: anoncvs troubles (was Re: CVS vs anoncvs) |
| Previous Message | Tille, Andreas | 2001-09-20 10:24:38 | Re: Performance question (stripped down the problem) |