Order by and words beginning with capitals

From: "Tjibbe Rijpma" <t(dot)b(dot)rijpma(at)student(dot)tudelft(dot)nl>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Order by and words beginning with capitals
Date: 2005-01-28 23:29:26
Message-ID: 001701c50591$35932640$0100a8c0@TJIBBE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-01-29 00:15:32 Re: Order by and words beginning with capitals
Previous Message Bruno Wolff III 2005-01-28 21:29:18 Re: How To Create DATETIME Data Types in A Table