[SQL] Add: Special sort querstion

2009-03-27 Thread Dominik Piekarski
achieve the same result? Dominik Piekarski schrieb: Hello everyone, the following query SELECT id, start_lat, start_lng, end_lat, end_lng FROM strecken WHERE ST_Intersects(strecke, geomfromtext('POLYGON(( 52.5204252 13.3169317, 52.5407887 13.3169317, 52.5407887 13.3534097, 52.5204252 13.35

[SQL] Special sort querstion

2009-03-25 Thread Dominik Piekarski
Hello everyone, the following query SELECT id, start_lat, start_lng, end_lat, end_lng FROM strecken WHERE ST_Intersects(strecke, geomfromtext('POLYGON(( 52.5204252 13.3169317, 52.5407887 13.3169317, 52.5407887 13.3534097, 52.5204252 13.3534097, 52.5204252 13.3169317 ))')) ORDER BY id; produces by