Re: Order by and words beginning with capitals

"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