All,
I am looking for a generic solution to get the Alphanumeric sorting.
· The user can request for any field to be sorted.
· There is no specific format the alphanumeric string can follow. So that we can split using regex and split and sorted.
· Need an efficient way. Should not degrade performance.
I tried all possible collation example -- select * from test order by name collate "en_US";
Is there someone who has solved this problem with writing a function?
Below are more details –
Database
![](/media/maillist_attaches/pgsql-general/2013/03/22/5D5078F9198B04449B9D74EA9E7F3D580CD265B6@G1W3640.americas.hpqcorp.net/image001.png)
Table
![](/media/maillist_attaches/pgsql-general/2013/03/22/5D5078F9198B04449B9D74EA9E7F3D580CD265B6@G1W3640.americas.hpqcorp.net/image002.png)
Rows with orderby
![](/media/maillist_attaches/pgsql-general/2013/03/22/5D5078F9198B04449B9D74EA9E7F3D580CD265B6@G1W3640.americas.hpqcorp.net/image003.png)
I am expecting
1, bay1
2, bay2
10, bay10
11, bay11
-vidhya