On Fri, Mar 27, 2009 at 6:10 AM, Dominik Piekarski
<d.piekarski@vivawasser.de> wrote:
> Oh, actually every row of the same id-range has the same start_lat/start_lng
> coordinates as the predecessors end_lat/end_lng coordinates. But the
> question remains the same. Is there a way to do something like ORDER BY
> (start_lat = end_lat AND start_lng = end_lng) ? Or maybe another way to
> achieve the same result?
Would something like
order by start_lat-endlat, start_lng-end_lng
OR
case when start_lat=end_lat AND start_lng=end_lng then 0 else 1 end
???