Postgres Pro
Downloads
Home   >   mailing lists

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

From Martín Marqués
Subject Re: Alphanumeric natural order sorting : need generic solution
Date
Msg-id CABeG9Lv0g3qOU1i3GWA+Gs2HZsa5b-dCPQ8_X0hp7tVfPCTg3Q@mail.gmail.com
Whole thread Raw
In response to Re: Alphanumeric natural order sorting : need generic solution  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
2013/3/22 John R Pierce <pierce@hogranch.com>
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;


That would be true if the last digits of the name attribute is equal to the id attribute (which would mean that there is redundancy).


--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
Attachment

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13
Next
From: Misa Simic
Date:
Subject: Re: How to join table to itself N times?