Обсуждение: Order by and words beginning with capitals

Поиск
Список
Период
Сортировка

Order by and words beginning with capitals

От
"Tjibbe Rijpma"
Дата:
How can I make a query like this:
 
SELECT id, words FROM words ORDER BY upper(words)
 
That I get a result like this (with the capitals intact but ordered correctly):
 
1. bear
2. cat
3. Dog
4. fish
5. Giraffe
 
Tjibbe
 
 
ps
 
SELECT id, words, upper(words) FROM words ORDER BY upper(words)
 
Works, but that's not what I'm looking for.

Re: Order by and words beginning with capitals

От
Tom Lane
Дата:
"Tjibbe Rijpma" <t.b.rijpma@student.tudelft.nl> writes:
> How can I make a query like this:

> SELECT id, words FROM words ORDER BY upper(words)

> That I get a result like this (with the capitals intact but ordered =
> correctly):

> 1. bear
> 2. cat
> 3. Dog
> 4. fish
> 5. Giraffe

Works for me.  Perhaps you should explain what problem you're having.

(A first guess is that you don't have your locale set up correctly,
but with no information that's strictly a guess.)

            regards, tom lane