Re: Alphanumeric natural order sorting : need generic solution

Martín Marqués <martin.marques@xxxxxxxxx> · Fri, 22 Mar 2013 13:38:10 -0300

2013/3/22 John R Pierce <pierce@xxxxxxxxxxxx>

    On 3/22/2013 12:40 AM, Umashanker,
      Srividhya wrote:

      Rows with orderby

      I am expecting 

      1, bay1
      2, bay2
      10, bay10
      11, bay11

    ...  order by id,name;

That would be true if the last digits of the name attribute is equal to the id attribute (which would mean that there is redundancy).

-- 
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'

DBA, Programador, Administrador