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@mportal.hu> wrote in message news:3D85BD61.7080208@mportal.hu...
> 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
> >
> >
> >
> >
> >
>
>
