From: Bruno Wolff III <bruno@wolff.to>
To: Gregor Rot <zara4tustra@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: order of results
Date: Fri, 26 Mar 2004 15:53:03 -0600
Message-ID: <20040326215303.GC21119@wolff.to> (raw)
In-Reply-To: <S2B8c.6954$%x4.923499@news.siol.net>
References: <S2B8c.6954$%x4.923499@news.siol.net>
On Thu, Mar 25, 2004 at 14:23:00 +0100,
Gregor Rot <zara4tustra@yahoo.com> wrote:
> Hi,
>
> i have a table called "people" (name:varchar, lastname:varchar).
>
> i do a select on it:
>
> select * from people where name like '%n1%' or lastname like '%l1%'.
>
> i would like the results in this order:
>
> first the results that satisfy only the (name like '%n1%') condition,
> then the ones that satisfy only the (lastname like '%l1%') condition and
> last the results that satisfy both conditions.
>
> Is this possible in only one SQL?
> (note that the search conditions n1 and l1 differ from search to search.
Yes. You can order by true/false results from conditions to get the
results in the desired order.
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: bruno@wolff.to, zara4tustra@yahoo.com
Subject: Re: order of results
In-Reply-To: <20040326215303.GC21119@wolff.to>
* 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