Re: Alphanumeric natural order sorting : need generic solution

From: Martín Marqués <martin(dot)marques(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Alphanumeric natural order sorting : need generic solution
Date: 2013-03-22 16:38:10
Message-ID: CABeG9Lv0g3qOU1i3GWA+Gs2HZsa5b-dCPQ8_X0hp7tVfPCTg3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2013/3/22 John R Pierce <pierce(at)hogranch(dot)com>

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Misa Simic 2013-03-22 19:45:12 Re: How to join table to itself N times?
Previous Message Denver Timothy 2013-03-22 16:14:45 PostgreSQL EXCLUDE USING error: Data type integer has no default operator class