sum(if command - Mailing list pgsql-general

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