select sum(TotShippingHandling) from Invoice where 1 = 1 and
TotShippingHandling <> 0;
---
   
(1 row)


select sum(TotShippingHandling) from Invoice where TotShippingHandling <> 0;
sum
-------
6781.05
(1 row)


Red Hat 5.1, intel, PostgreSQL 6.5 (downloaded last night).

Thanks, Michael

Tue, 30 Mar 1999 15:23:59 -0600
Michael Davis <michael.davis@prevuenet.com>
Interesting failure when selecting aggregates