<br><blockquote class="gmail_quote" style="margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;">
<br>De ha valaki tudja, hogy lehet 2 poligont beadni az st_within()
<br>függvények, az is jó. :-)
<br>
<br>select DISTINCT(name) from planet_osm_line where highway != '' and name
<br>!= '' and
<br>st_within(way, (select way from planet_osm_polygon where
<br>boundary='administrative' and name='Kőszegszerdahely'))
<br>
<br>ERROR: more than one row returned by a subquery used as an expression
<br>
</blockquote><div> </div><div> Tanulni,tanulni,tanulni.....<br>Ez akkor is jó ha 20 polygon van::<br>select r.name from planet_osm_line r, planet_osm_polygon m where ST_Contains(m.way, r.way) and r.highway<>'' and m.admin_level='8' and m.name = 'Kőszegszerdahely' group by r.name order by r.name asc;<br></div>