On Fri, Mar 27, 2009 at 6:10 AM, Dominik Piekarski <d.piekar...@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 ??? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql