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

Adam Ruth <aruth@intercation.com> writes:

> Due to the sorting of boolean values, you'd need:
>
> ORDER BY language = 'DK' desc, language like '%DE' desc, language;

Personally I find something like this clearer:

ORDER BY (CASE WHEN language = 'DK' THEN 1
               WHEN language like '%DE' THEN 2
               WHEN ...
               ELSE 5
               END
         )

--
greg