Sorting varchar w/single digits

From: Robert Fitzpatrick <robert(at)webtent(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Sorting varchar w/single digits
Date: 2004-08-11 00:54:45
Message-ID: 1092185684.24833.3.camel@columbus.webtent.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have varchar column with both numbers and letters, like 1 thru 10 and
5A thru 5G, they are unit numbers for apartments. If I have 1 thru 100,
since it is a varchar field, it sorts like 1,10,11... instead of
1,2,3...

Is there any way to handle this without having to make a sort order
column?

--
Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message lec 2004-08-11 01:30:12 Re: Losing records when server hang
Previous Message Sven Willenberger 2004-08-10 23:28:12 Re: pg_restore with Fc fails with [archiver] out of memory