>Dear all
>I am trying to execute the following query in postgresql, but keep getting errors ("error near group by"). Tried to run it in pgadmin's query tool, and got different errors ( like IIF not recognized ). Can anyone help me "translate" the sql from vfp to postgre?
>Table name in postgre: weblog
>Fields: agent C(4), function varchar(20), xmlstr text
>

>lcStr = [select weblog.agent, ]+;
>[sum(iif(weblog.function="GetCars" or "GETCARS"$weblog.xmlstr,1,0)) as RateRequests,]+;
>[sum(iif(weblog.function="CarRes" or "CARRES"$weblog.xmlstr,1,0)) as Bookings ]+;
>[from weblog order by weblog.agent group by weblog.agent]
>=sqlexec( oConnection,  lcStr, "TempCursor" )
>

>TIA
>Jaime

Don't know if the SQL Server T-SQL syntax has something common with postgre, but here the SQL Server version:

TEXT TO lcStr NOSHOW
     select weblog.agent,
            SUM(CASE WHEN weblog.function = 'GetCars' OR
                         CHARINDEX('GETCARS', weblog.xmlstr) > 0
                     THEN 1 
                     ELSE 0 END) as RateRequests,
            SUM(CASE WHEN weblog.function = 'CarRes' OR
                         CHARINDEX('CarRes', weblog.xmlstr) > 0
                     THEN 1 
                     ELSE 0 END) as Bookings
     from weblog
     group by weblog.agent --- Group must be before ORDER BY
     order by weblog.agent
ENDTEXT