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 any on docs.
Thnx, Alejandro
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
