Re: ORDER BY 'DK', 'DE', DESC? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: ORDER BY 'DK', 'DE', DESC?
Date
Msg-id 20040520111840.G18583@megazone.bigpanda.com
Whole thread Raw
In response to Re: ORDER BY 'DK', 'DE', DESC?  (Adam Ruth <aruth@intercation.com>)
Responses Re: ORDER BY 'DK', 'DE', DESC?  (Adam Ruth <aruth@intercation.com>)
List pgsql-general
On Thu, 20 May 2004, Adam Ruth wrote:

>
> On May 20, 2004, at 11:20 AM, Stephan Szabo wrote:
>
> > On Tue, 11 May 2004, [ISO-8859-1] Victor Spång Arthursson wrote:
> >
> >> Hi!
> >>
> >> I would like to know if it's possible to give a priority order of how
> >> to sort the returning rows?
> >>
> >> Like for example to order every row with a field language = DK first,
> >> then the rows with field language = *DE' and last the other languages,
> >> ordered alphabetically…?
> >
> > Well, I think you can do something like:
> >
> > ORDER BY (language = 'DK'), (language = 'DE'), language
> >
> > (or you could possibly condense the first two into one with case)
>
> Due to the sorting of boolean values, you'd need:
>
> ORDER BY language = 'DK' desc, language like '%DE' desc, language;

Yep, someday I'll remember that 0 is less than 1. ;)


pgsql-general by date:

Previous
From: Adam Ruth
Date:
Subject: Re: ORDER BY 'DK', 'DE', DESC?
Next
From: Liviu BURCUSEL
Date:
Subject: Problem converting interval to seconds