Thread: Order by and words beginning with capitals
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.
"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