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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
