From: Gregor Rot <zara4tustra@yahoo.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.6) Gecko/20040113
MIME-Version: 1.0
Subject: Re: order of results
References: <S2B8c.6954$%x4.923499@news.siol.net>
	<20040326215303.GC21119@wolff.to>
In-Reply-To: <20040326215303.GC21119@wolff.to>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 29
Message-ID: <QrAbc.238$37.31493@news.siol.net>
Date: Sat, 03 Apr 2004 17:08:34 +0200
Organization: Slovenija OnLine - SiOL
To: pgsql-sql@postgresql.org

Bruno Wolff III wrote:
> 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.

Thank you - sorry, but how do you do that?

Tnx,
Gregor