| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Umashanker, Srividhya *EXTERN*" <srividhya(dot)umashanker(at)hp(dot)com>, "pgeu-general(at)postgresql(dot)org" <pgeu-general(at)postgresql(dot)org> |
| Subject: | Re: Alphanumeric natural order sorting |
| Date: | 2013-03-20 08:46:49 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B057C9978@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgeu-general pgsql-general |
Umashanker, Srividhya wrote:
>> I am looking for a solution the Alphanumeric sorting
>> I am expecting
>> 1, bay1
>> 2, bay2
>> 10, bay10
>> 11, bay11
> We are working on a framework, where the client can
>
> * call for sort on any colmn.
> * The digits may or may not be there
> * The numeric can be anywhere in the string
That's easy then.
Just define exactly how you want the ordering to be,
and based on that definition you can write code for
sorting.
How would you sort
'bay10', 'ba1y0', 'ba10y', 'ba2y0'?
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2013-03-22 10:16:42 | Re: [pgeu-general] Alphanumeric natural order sorting |
| Previous Message | Umashanker, Srividhya | 2013-03-20 08:18:30 | Re: Alphanumeric natural order sorting |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2013-03-20 09:35:04 | Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13 |
| Previous Message | Umashanker, Srividhya | 2013-03-20 08:18:30 | Re: Alphanumeric natural order sorting |