>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

[from weblog group by weblog.agent order by weblog.agent]