please try it. it does work! qgis filter is usually accepting all valid sql queries.

filter: lower("value") similar to '(berlin|london|paris)'

https://wambachers-osm.website/images/osm/snaps_2017/similar.png

ok, havin problems with hstore, but that's is another question.

regards
walter

Am 28.07.2017 um 13:31 schrieb "Torben Keßler":
Thanks! Just erased the wildchars to shorten the code.
I forgot to mention that I'm trying this as a QGIS (v 2.18.7) filter, not in ProstgreSQL. There, I have only "ilike" as suitable string operator, it seems.
Best,
Torben


_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to