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 this could 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 see anything 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(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"The fear of the LORD is the instruction of wisdom, and
before honour is humility." Proverbs 15:33