Re: Sort order with spaces?

On Wednesday 17 September 2003 13:39, Kristian Jörg wrote:
> Kristian Jörg wrote:
> > Richard Huxton wrote:
> >>>
> >>>LUNDGREN
> >>>M L R
> >>>MACDOWELL
> >>>MUSCLE
> >>>
> >>>But in Postgres I get this order:
> >>>
> >>>LUNDGREN
> >>>MACDOWELL
> >>>M L R
> >>>MUSCLE
> >>

> Woops, a type above. My sql is of course:
> select * from mytable where normtext>= 'LU' order by normtext;

richtest=# select * from foo order by b;
a | b
---+-----------
1 | LUNDGREN
2 | M L R
3 | MACDOWELL
4 | MUSCLE
(4 rows)

LC_MESSAGES = 'C'
LC_MONETARY = 'C'
LC_NUMERIC = 'C'
LC_TIME = 'C'

Might be worth checking the release notes on the website to see if there's
anything mentioned.

--
Richard Huxton
Archonet Ltd