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