[GENERAL] problem with ORDER BY

Hello, I do not understand why the following ORDER BY statment does not work as I would expect: 1) I defined a simple table with only one column, containing urls: mon=> \d url Table "public.url" Column | Type | Modifiers +--+--- url| text | not null Indexes: "ur

Re: [GENERAL] problem with ORDER BY

Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > On Fri, Feb 01, 2008 at 11:06:07AM +0100, Nicolas KOWALSKI wrote: >> >> I do not understand why the following ORDER BY statment does not work >> as I would expect: >> >> 3) When I want to sort them, I g

Re: [GENERAL] problem with ORDER BY

Tom Lane <[EMAIL PROTECTED]> writes: > The ordering you showed is correct according to en_US (and most other > non-C locales). The ordering you want is used in "C" locale. > Unfortunately you have to re-initdb to change the locale of a > database :-( > initdb --locale=C Thanks Tom, using t

Re: [GENERAL] problem with ORDER BY

"Vyacheslav Kalinin" <[EMAIL PROTECTED]> writes: > I am guessing that collation rules are not applied to bytea columns, so one > can compare text according to C locale anyway if he populates bytea column > or just does something like > > select * from url order by byteain(textout(url)) Thanks for