Home > mailing lists

Order by and words beginning with capitals - Mailing list pgsql-novice

From	Tjibbe Rijpma
Subject	Order by and words beginning with capitals
Date	January 29, 2005 02:25:59
Msg-id	001701c50591$35932640$0100a8c0@TJIBBE Whole thread Raw
Responses	Re: Order by and words beginning with capitals (Tom Lane <tgl@sss.pgh.pa.us>)
List	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

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

Works, but that's not what I'm looking for.

From: Bruno Wolff III
Date: 29 January 2005, 00:15:11
Subject: Re: How To Create DATETIME Data Types in A Table

From: Tom Lane
Date: 29 January 2005, 03:15:45
Subject: Re: Order by and words beginning with capitals