Re: [GENERAL] Order by and strings

2010-02-09 Thread Magnus Hagander
On Tue, Feb 9, 2010 at 11:21, Fredric Fredricson wrote: > Scott Marlowe wrote: > > On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson > wrote: > > > I use locale en_US.UTF-8 but why this should affect how leading characters > in strings are ignored is beyond me. > > > P.s. this page may shed some

Re: [GENERAL] Order by and strings

2010-02-09 Thread Fredric Fredricson
Scott Marlowe wrote: On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson wrote: I use locale en_US.UTF-8 but why this should affect how leading characters in strings are ignored is beyond me. P.s. this page may shed some light on the subject: http://en.wikipedia.org/wiki/Collation OK,

Re: [GENERAL] Order by and strings

2010-02-09 Thread Scott Marlowe
On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson wrote: > I use locale en_US.UTF-8 but why this should affect how leading characters > in strings are ignored is beyond me. P.s. this page may shed some light on the subject: http://en.wikipedia.org/wiki/Collation -- Sent via pgsql-general mail

Re: [GENERAL] Order by and strings

2010-02-09 Thread Scott Marlowe
On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson wrote: > Justin Graf wrote: > > On 2/8/2010 7:09 PM, Fredric Fredricson wrote: > > Hi! > New to the list with a question that I cannot find the answer to in the > manual or on the internet but I suspect is trivial. If somebody could point > me in

Re: [GENERAL] Order by and strings

2010-02-09 Thread Fredric Fredricson
Justin Graf wrote: On 2/8/2010 7:09 PM, Fredric Fredricson wrote: Hi! New to the list with a question that I cannot find the answer to in the manual or on the internet but I suspect is trivial. If somebody could point me in the correct direction I would be greatful. This is what I do (conden

Re: [GENERAL] Order by and strings

2010-02-08 Thread Justin Graf
On 2/8/2010 7:09 PM, Fredric Fredricson wrote: > Hi! > New to the list with a question that I cannot find the answer to in > the manual or on the internet but I suspect is trivial. If somebody > could point me in the correct direction I would be greatful. > > This is what I do (condensed, of cour