Thread: Order by and words beginning with capitals

Order by and words beginning with capitals

From
"Tjibbe Rijpma"
Date:
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

From
Tom Lane
Date:
"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