Umashanker, Srividhya wrote:
> 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 -

> I am expecting
> 
> 1, bay1
> 2, bay2
> 10, bay10
> 11, bay11

The answer is the same as on the other mailing list:

Define precisely (not only with an example) what you mean
by "alphanumeric sorting" and you are more likely to get a helpful answer.

Yours,
Laurenz Albe


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to