[mapserver-users] SLD with filter

[Daniel Degasperi]

Hi,
I've a problem with following filter:

<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
<ogc:PropertyIsEqualTo matchCase="true">
<ogc:PropertyName>localita</ogc:PropertyName>
<ogc:Literal>1.102</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Filter>

Output:
<?xml version="1.0" encoding="ISO-8859-1"?>
<ows:ExceptionReport 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns:ows="http://www.opengis.net/ows" version="1.1.0" language="en-US" 
xsi:schemaLocation="http://www.opengis.net/ows 
http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd">
<ows:Exception exceptionCode="mapserv" locator="NoApplicableCode">
<ows:ExceptionText>msWFSGetFeature(): WFS server error. 
FLTApplyFilterToLayer() failed
msPostGISLayerWhichShapes(): Query error. Error (ERROR:  operator does 
not exist: text = numeric
LINE 1: ...6966392 4130435.36164853))',32632) and ( (localita= 1.102) )
                                                              ^
HINT:  No operator matches the given name and argument type(s). You 
might need to add explicit type casts.
) executing query: select 
"gc_objid","di_id","localita","di_name_1",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex') 
as geom,"gc_objid" from (SELECT  __data__.di_id as 
gc_objid,__data__.the_geom, 
__data__.di_id,__data__.localita,__data__.di_name_1 FROM 
geo.district_area AS __data__) AS foo where the_geom &amp;&amp; 
GeomFromText('POLYGON((-393764.596966392 
4130435.36164853,-393764.596966392 5936656.6234314,1412456.59042116 
5936656.6234314,1412456.59042116 4130435.36164853,-393764.596966392 
4130435.36164853))',32632) and ( (localita= 1.102) )</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>

It seems that the value 1.102 is not quoted. Should I add the attribute 
xs:type="string" to the literal node or use the PropertyIsLike condition?

I'm using MapServer 5.6.6

Best regards,
Daniel


-- 
Daniel Degasperi R3 GIS Srl - GmbH www.r3-gis.com