I have been trying to do an 'or' function such that if a field value is
zero then use 1 as a multiplier:
"select sum((1 | i.count) * s.cost) as COST
seems to work ok when the value is 0 but I get the wrong value is
i.count in not zero
stid | count | tot | ldate | pkcnt | status | cost
------+-------+-----+------------+-------+--------+------
2995 | 12 | 44 | 12/18/2006 | 32 | Active | 3.60
qs "select sum(i.count * s.cost) from inventory i,stock s, stockkey k
where i.stid=s.stid and i.status='Active' and s.ctype = k.cd and k.value
= 'Other' and s.ssp = 'Stock'"
sum
-------
43.20
qs "select sum((1|i.count) * s.cost) from inventory i,stock s, stockkey k
where i.stid=s.stid and i.status='Active' and s.ctype = k.cd and k.value
= 'Other' and s.ssp = 'Stock'"
sum
-------
46.80
43.20 <> 46.80
Thanks
--
Arthur R. Van Hook
Mayor
The City of Lake Lotawana
[EMAIL PROTECTED]
(816) 578-4704 - Home
(816) 578-4215 - City
(816) 564-0769 - Cell
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
