Re: or function

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"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