Re: [HACKERS] ordering RH6.1

Tom Lane wrote: >Bizarre.  I see the expected results under both 6.5.3 and current >development sources: > >play=>
SELECT* FROM BLANK order by column1; >column1 >------- >      1 >      2 >     11 >    100 >(4 rows) > >I wonder if
thiscould be a LOCALE or MULTIBYTE issue.  Do you have >either feature enabled in your copy, and if so what
locale/encoding>do you use?  (I'm running plain vanilla no-USE_LOCALE, no-MULTIBYTE >code, so that might be why I don't
seeanything funny...)
 

I've tried this with both locale and multibyte enabled and with
LANG=en_GB.  The results are correct.  (Version = 6.5.3).
--      Vote against SPAM: http://www.politik-digital.de/spam/                ========================================
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver              PGP key from public servers; key
ID32B8FAA1                ========================================    "The fear of the LORD is the instruction of
wisdom,and     before honour is humility."      Proverbs 15:33