Hi,

I've just added the hstore_get_value() to both OGR SQL and SQLite dialects. 
This can be especially useful with the OSM driver to extract values associated 
to a key from the other_tags attribute that has a HSTORE formatting ( 
http://www.postgresql.org/docs/9.0/interactive/hstore.html )

From the doc:
"""
Starting with OGR 2.0, the hstore_get_value() function can be used to extract 
a value associate to a key from a HSTORE string, formatted like 
"key=>value,other_key=>other_value,..."
SELECT hstore_get_value('a => b, "key with space"=> "value with space"', 'key 
with space') --> 'value with space'
"""

Even

-- 
Geospatial professional services
http://even.rouault.free.fr/services.html
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to