Re: or function

"A. R. Van Hook" <hook@lake-lotawana.mo.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