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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
