Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: or function
- From: chester c young <chestercyoung(at)yahoo(dot)com>
- To: "A. R. Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: or function
- Date: Sat, 30 Dec 2006 10:10:38 -0800 (PST)
--- "A. R. Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us> wrote: > 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 ... try "select sum( (case when i.count=0 then 1 else i.count end) * s.cost ) as COST ... __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
- References:
- or function
- From: A. R. Van Hook
- or function
- Prev by Date: or function
- Next by Date: Re: or function
- Previous by thread: or function
- Next by thread: Re: or function
- Indexes: