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 | LUNDGREN2 | M L R3 | MACDOWELL4 | 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