mysql "case": http://www.mysql.com/doc/en/Control_flow_functions.html
postgres "case":
http://www.postgresql.org/idocs/index.php?functions-conditional.html
C.
king wrote:
> Hi,
>
> Does posgres support the equivalent to the mysql sum(if command in a SQL
> statement? I did not see reference to it in my readings.
>
> For example:
> SELECT STYLENO, SUM(IF(RECORDTYPE='5', TOTALQTY,0)) AS 'ONHAND'
> FROM WHOE314 WHERE SEASON='202' AND STYLENO NOT LIKE'S%'
> GROUP BY SEASON, STYLENO
>
>
> thanks
>
>
>
>
>