Re: sum(if command

Col,

I should have been more specific. I should have completed the query.

SELECT STYLENO, SUM(IF(RECORDTYPE='5', TOTALQTY,0)) AS 'ONHAND'
SUM(IF(RECORDTYPE='6', TOTALQTY,0)) AS 'ONORDER'
FROM WHOE314 WHERE SEASON='202' AND STYLENO NOT LIKE'S%'
GROUP BY SEASON, STYLENO

result:
STYLENO | ONHAND | ONORDER
===========================
41321 | 210 | 195
19219 | 101 | 98

What I need to be able to do is cross tabulate the information. like in the
above mysql sql statement. Will the "case" function in postgres allow this?

Thanks

"CoL" <col(at)mportal(dot)hu> wrote in message news:3D85BD61(dot)7080208(at)mportal(dot)hu(dot)(dot)(dot)
> 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
> >
> >
> >
> >
> >
>
>