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