From: Scott Marlowe <scott.marlowe@gmail.com>
To: d.piekarski@vivawasser.de
Cc: pgsql-sql@postgresql.org
Subject: Re: Add: Special sort querstion
Date: Wed, 1 Apr 2009 09:08:26 -0600
Message-ID: <dcc563d10904010808p52118a7ah3ff78029b3a91c3a@mail.gmail.com> (raw)
In-Reply-To: <49CCC24A.90800@vivawasser.de>
References: <49CA6121.8090704@vivawasser.de>
<49CCC24A.90800@vivawasser.de>
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
???
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@gmail.com, d.piekarski@vivawasser.de
Subject: Re: Add: Special sort querstion
In-Reply-To: <dcc563d10904010808p52118a7ah3ff78029b3a91c3a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox