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