Il 11/01/2014 02:40 PM, Andrea Aime scrisse:
> Hum... I believe strMatch matches the whole string, so you should add .*
> before and after your pattern:
That's it!
Thank you
maxx
--
_
On Sat, Nov 1, 2014 at 2:15 PM, emmexx wrote:
> Il 11/01/2014 02:01 PM, Andrea Aime scrisse:
> >
> > Even if there was this ability, you'd still have to specify the
> > matching pattern using the Java Pattern syntax, and the
> > SQL translator would have to turn it into the native one instead
>
>
Il 11/01/2014 02:01 PM, Andrea Aime scrisse:
>
> Even if there was this ability, you'd still have to specify the
> matching pattern using the Java Pattern syntax, and the
> SQL translator would have to turn it into the native one instead
Thank you Andrea,
from what I read (google, forums, javadoc
Hi Emmex,
filter functions are generally not translated down in SQL.
Postgis is actually the one exception that has a handful of sample
functions translated to sql, but strMatches is not one of them.
Even if there was this ability, you'd still have to specify the
matching pattern using the Java P
I'm not sure if this is the right place to as.
I tried to create a style using a regex to match the values in a postgis
table.
I wrote the following:
tags
\b(15|3|8)\b
true
The field "tags" is a varchar and the values in it are integers