Re: [GENERAL] If statements on select

On Fri, Apr 15, 2005 at 09:13:40AM -0300, Alejandro D. Burne wrote: > Hi, I'm translating an app made with visual foxpro and mysql as rdbms > to postgres. > I've got many querys with this sintax: > > select code1, sum(if(cond1, price,0)), sum(if(cond2,price,0)) from ... Use CASE WHEN cond1 THEN p

[GENERAL] If statements on select

Hi, I'm translating an app made with visual foxpro and mysql as rdbms to postgres. I've got many querys with this sintax: select code1, sum(if(cond1, price,0)), sum(if(cond2,price,0)) from ... may be it's not sql compliant but very usefull there is a way to do this work on postgres? I can't find