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)
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La naturaleza, tan frágil, tan expuesta a la muerte... y tan viva"