[postgis-users] Postigs layer in Mapserver

[Oscar Testa]

Hello, iam using Postgis layers with mapserver and php_mapscript.

When a layer data property has de simple value DATA "the_geom from 
xxx", the result is correct. 
But when i try the next:

  DATA "the_geom from (select locarg.the_geom, locarg.oid, count(*) as 
cantidad from locarg, lugar where locarg.codpostal = lugar.codigopostal 
group by 1,2) as prueba"

the next error appear:

MapServer Error in msPOSTGISLayerWhichShapes(): prep_DB:Error executing 
POSTGIS DECLARE statement (0.6 failed - retried 0.5 and it failed too). 
DECLARE mycursor BINARY CURSOR FOR SELECT Provincia::text,asbinary
(force_collection(force_2d(the_geom)),'NDR'),OID::text from (select 
locarg.the_geom, locarg.oid, count(*) as cantidad from locarg, lugar 
where locarg.codpostal = lugar.codigopostal group by 1,2) as prueba 
WHERE the_geom && setSRID('BOX3D(-78.22636066 -55.575152,-48.54710934 -
20.90357)'::BOX3D, find_srid('','locarg,','the_geom') )

Any idea??

Oscar