ORDER BY 'DK', 'DE', DESC?

From: Victor Spång Arthursson <scooterbabe(at)home(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: ORDER BY 'DK', 'DE', DESC?
Date: 2004-05-11 08:46:59
Message-ID: C3D41FDA-A327-11D8-99EA-00039344A3C4@home.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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…?

Sincerely

Victor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Victor Spång Arthursson 2004-05-11 08:51:34 Equivalent for mysql's FOUND_ROWS()
Previous Message Paul Thomas 2004-05-11 07:42:44 Re: Very slow query