[Maps-l] Simpler psql statement

[Thomas Ineichen]

Hi,

to  see  what  keys there are for rendering on my bicycle map, I query
the db for %cycle%:

SELECT key, count(*)
FROM (
     SELECT (each(tags)).key
     FROM planet_osm_line
) AS stat
WHERE key LIKE '%cycle%'
GROUP by key
ORDER by count DESC


As  this is rather slow, I was trying to take the %cycle% to the inner
query.  But  how  can  I trigger the keys in 'tags'? And would that be
really faster?


Thanks for any hint,
Thomas