Re: [SQL] Ordering a name list and ignoring whitespace

2009-04-16 Thread Tom Lane
Mikel Lindsaar writes: > I'm trying to select a list of names in alphabetical order but > ignoring the whitespace. > So for example, the name "La Combe" should come after "Lace" but > before "Lacs..." FWIW, this would probably happen automatically if you were using a non-C locale. I'm not sure

Re: [SQL] Ordering a name list and ignoring whitespace

2009-04-16 Thread Mario Splivalo
Mikel Lindsaar wrote: Hi all, Doing some googling and looking through the docs, I can't find an obvious way to do this beside post processing after the query (which I am trying to avoid). I'm trying to select a list of names in alphabetical order but ignoring the whitespace. So for example, th

[SQL] Ordering a name list and ignoring whitespace

2009-04-16 Thread Mikel Lindsaar
Hi all, Doing some googling and looking through the docs, I can't find an obvious way to do this beside post processing after the query (which I am trying to avoid). I'm trying to select a list of names in alphabetical order but ignoring the whitespace. So for example, the name "La Combe" should