Interesting failure when selecting aggregates

Started by Michael Davisalmost 27 years ago1 messages
#1Michael Davis
michael.davis@prevuenet.com

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