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) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
