This may have to do with the geotools regex (java.util.regex) doesn't
translate to postgresql's internal regex
http://www.postgresql.org/docs/8.1/static/functions-matching.html
Can you capture the queries sent by geoserver to the postgis database on
requesting the labels?
If it turns out to indeed be an issue, maybe geotools should be altered
instead of geoserver?
2011/2/11 Edward Mac Gillavry <emacgilla...@hotmail.com>
> As I mentioned in my previous email, I got the SLD with ECQL filter
> working on ESRI shapefiles (both the TIGER poly_landmarks that comes with
> GeoServer and an ESRI shapefile I created through ogr2ogr from my PostGIS
> table).
>
> However, having added the poly_landmarks.shp to my PostGIS database through
> ogr2ogr, the same SLD with ECQL filter I used for the poly_landmarks.shp
> does NOT work on the PostGIS table.
>
> - client_encoding of the PostGIS database is utf8
> - postgis_full_version: POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel.
> 4.7.1, 23 September 2009" LIBXML="2.7.6" USE_STATS
>
> HTH
>
> Edward
>
>
>
> > Date: Thu, 10 Feb 2011 15:42:45 +0100
>
> > Subject: Re: [Geoserver-users] How to filter road numbers in SLD using
> [SEC=Unclassified] propertyislike? [SEC=Unclassified]
> > From: andrea.a...@geo-solutions.it
> > To: emacgilla...@hotmail.com
> > CC: geoserver-users@lists.sourceforge.net
>
> >
> > On Thu, Feb 10, 2011 at 3:06 PM, Edward Mac Gillavry
> > <emacgilla...@hotmail.com> wrote:
> > > Updated to Geoserver 2.1 beta1! Pardon my ignorance, but how would I
> > > reformulate the ECQL filter strMatches(CFCC, 'D\d+') = true in an SLD?
> What
> > > to put between <ogc:Filter> ... </ogc:Filter>?
> >
> > See my previous mail, it has an example:
> >
> > <ogc:Filter>
> > <ogc:PropertyIsEqualTo>
> > <ogc:Function name="strMatches">
> > <ogc:PropertyName>CFCC</ogc:PropertyName>
> > <ogc:Literal>D\d+</ogc:Literal>
> > </ogc:Function>
> > <ogc:Literal>true</ogc:Literal>
> > </ogc:PropertyIsEqualTo>
> > </ogc:Filter>
> >
> > Cheers
> > Andrea
> >
> >
> > --
> > -------------------------------------------------------
> > Ing. Andrea Aime
> > GeoSolutions S.A.S.
> > Tech lead
> >
> > Via Poggio alle Viti 1187
> > 55054 Massarosa (LU)
> > Italy
> >
> > phone: +39 0584 962313
> > fax: +39 0584 962313
> > mob: +39 333 8128928
> >
> > http://www.geo-solutions.it
> > http://geo-solutions.blogspot.com/
> > http://www.youtube.com/user/GeoSolutionsIT
> > http://www.linkedin.com/in/andreaaime
> > http://twitter.com/geowolf
> >
> > -------------------------------------------------------
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
