"A. R. Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us> writes:
> 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
Bitwise OR will surely not do what you want. I think the most effective
solution is probably CASE:
select sum(case when i.count = 0 then s.cost else i.count * s.cost end) ...
regards, tom lane