natural sort order

From: Ken Guest <kguest(at)stockbyte(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: natural sort order
Date: 2003-02-14 15:14:19
Message-ID: 3E4D07CB.2090409@stockbyte.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to use a natural sort order?
I want to get data back in the order
CD1, CD2, CD3., CD4, CD5, CD6, CD7, CD8, CD9, CD10, CD11

not in this order
CD1, CD10, CD11, CD2.....

thanks

k.

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-02-14 15:33:40 Re: uppercase = lowercase
Previous Message Jeff Eckermann 2003-02-14 15:08:37 Re: uppercase = lowercase