Home > mailing lists

Re: Alphanumeric natural order sorting : need generic solution - Mailing list pgsql-general

From	John R Pierce
Subject	Re: Alphanumeric natural order sorting : need generic solution
Date	March 22, 2013 13:12:21
Msg-id	514C2E7B.2070503@hogranch.com Whole thread Raw
In response to	Alphanumeric natural order sorting : need generic solution ("Umashanker, Srividhya" <srividhya.umashanker@hp.com>)
Responses	Re: Alphanumeric natural order sorting : need generic solution
List	pgsql-general

On 3/22/2013 12:40 AM, Umashanker, Srividhya wrote:

Rows with orderby

I am expecting

1, bay1
2, bay2
10, bay10
11, bay11

... order by id,name;

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

From: Albe Laurenz
Date: 22 March 2013, 13:03:32
Subject: Re: Alphanumeric natural order sorting : need generic solution

From: Heikki Linnakangas
Date: 22 March 2013, 13:16:50
Subject: Re: [pgeu-general] Alphanumeric natural order sorting