please need help: alpha numeric sorting - Mailing list pgsql-novice

From Raouf
Subject please need help: alpha numeric sorting
Date
Msg-id 000f01c23a01$6f17bc40$0201a8c0@pavilion
Whole thread Raw
Responses Re: please need help: alpha numeric sorting
List pgsql-novice
Hi Gurus,
 
I need your help for this one:
 
let's say I have 1 field of type VARCHAR that contains numbers (as ascii) and characters like this:
 
 
title
-----------
12.1 cisco ccnp routing
12.2 cisco ccnp remote access
12.11cisco ccnp switching
12.3 cisco ccnp support 
 
 
I'd like to sort that column in alphanumeric order, like this:
 
title
-----------
12.1 cisco ccnp routing
12.2 cisco ccnp remote access
12.3 cisco ccnp support 
12.11cisco ccnp switching
 
 
but if I sort using group by title and order by title asc I have:
 
 
title
-----------
12.1 cisco ccnp routing
12.11cisco ccnp switching
12.2 cisco ccnp remote access
12.3 cisco ccnp support 
12.11cisco ccnp switching
 
where "12.11cisco ccnp switching" is before "12.2 cisco ccnp remote access" because it is smaller.
 
Is it possible  ?
 
thanks for your help

pgsql-novice by date:

Previous
From: Ludwig Lim
Date:
Subject: Re: pg_restore not working
Next
From: "Markus Wollny"
Date:
Subject: Re: please need help: alpha numeric sorting