[Qgis-user] categorize using postgis hstore

[wambacher at posteo.de]

Hi,

i'm using QGIS 3.4 on ubuntu and want to categorize some data using hstore.

i was told (*) to use *map_get(hstore_to_map("tags"),'entrance')*, but
that does not work (for me). the result is ony one category for all nodes.

sql:

select osm_id,tags->'entrance' "tags->'entrance'"
  from planet_osm_point
 where tags ? 'entrance'
 limit 10;
   osm_id   | tags->'entrance'
------------+------------------
 3812284860 | main
 2312180146 | yes
 2773679231 | yes
  339015388 | main
  561073309 | service
  367081276 | main
  339015386 | yes
 1783531793 | main
 1783531816 | main
  367081281 | main
(10 Zeilen)

Zeit: 3,194 ms

any idea whats going wrong?

regards

walter

*)
https://gis.stackexchange.com/questions/209421/how-to-categorize-features-based-on-hstore-values-in-qgis/288550

image: https://wambachers-osm.website/images/osm/snaps_2018/categorize.png

-- 
My projects:

Admin Boundaries of the World <https://wambachers-osm.website/boundaries>
Missing Boundaries
<https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries>
Emergency Map <https://wambachers-osm.website/emergency>
Postal Code Map (Germany only) <https://wambachers-osm.website/plz>
Fools (QA for zipcodes in Germany) <https://wambachers-osm.website/fools>
Postcode Boundaries of Germany <https://wambachers-osm.website/pcoundaries>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20181229/8c66fd59/attachment.html>