Re: Sort order confusion

On Thursday 05 February 2004 5:01 pm, Alvaro Herrera wrote:
> On Fri, Feb 06, 2004 at 11:21:41AM +1100, Stephen Robert Norris
wrote:
> > On Fri, 2004-02-06 at 11:12, Steve Crawford wrote:
> > > I am suffering some sort order confusion. Given a database,
> > > "foo", with a single character(4) column of data left padded
> > > with spaces I get:
> > >
> > > select * from foo order by somechars;
>
> Cast it:
>
> alvherre=> select * from foo order by bar::text::int;
> bar
> ------
> 0
> 1
> 10
> 33
> 100
> 101
> 333
> 503
> (8 filas)

Can't. As noted in the original post the column may contain data that
won't convert to an int (all spaces, characters, punctuation). I'm
seeking generic true ASCII sort order.

Cheers,
Steve