[TinyOWS-users] Making WFS queries against hstore attribute

[Olivier Courtin]

>> What about already implemented FE PropertyIsLike operator ?
>> If hstore are also considered as SQL string, it should/could works.
>
> I am not very clever in writing filters and queries but you can try  
> PropertyIsLike with my server. It is a fresh TinyOWS rc1, and the  
> database behind is PostgreSQL 9.0 with PostGIS 1.5.2. If you want to  
> have your own database with hstore some day, it can be created from  
> OSM data with osm2pgsql by using the -k switch. Before that hstore  
> option must be added into the database by running the "hstore.sql"  
> script from the "contrib" directory.

http://188.64.1.61/cgi-bin/tinyows?service=wfs&version=1.1.0&request=getfeature&typename=tows:osm_polygon&maxfeatures=100&filter=%3Cogc:Filter%20xmlns:ogc=%22http://www.opengis.net/ogc%22%3E%3Cogc:PropertyIsLike%20wildCard=%27*%27%20singleChar=%27.%27%20escapeChar=%27!%27%3E%3Cogc:PropertyName%3Etows:tags%3C/ogc:PropertyName%3E%3Cogc:Literal%3ESaima%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E

The request looks fine, but doesn't output any feature.
Could you log the PostgreSQL request to find out why it's doesn't  
works for hstore column type ?

--
Olivier