eiros
- Original Message -
From: "Adrian Klaver"
To: "Oliveiros C,"
Cc: "Tom Lane" ;
Sent: Tuesday, October 20, 2009 2:46 PM
Subject: Re: [SQL] How to order varchar data by word
On Tuesday 20 October 2009 6:39:23 am Oliveiros C, wrote:
Hello, Tom.
Thank you fo
On Tuesday 20 October 2009 6:39:23 am Oliveiros C, wrote:
> Hello, Tom.
>
> Thank you for your e-mail
>
> Even though I am not familiar with the exact procedure to switch to other
> locales,
> I'm gonna research this more deeply.
>
> Anyway, I would appreciate if you could spare me some time and gi
Best,
Oliveiros
- Original Message -
From: "Tom Lane"
To: "Oliveiros C,"
Cc: "Adrian Klaver" ;
Sent: Monday, October 19, 2009 6:32 PM
Subject: Re: [SQL] How to order varchar data by word
"Oliveiros C," writes:
If any one can explain me exact
"Oliveiros C," writes:
> If any one can explain me exactly how the order by clause works on varchars,
> I 'd really appreciate it.
It sorts according to the sort order imposed by your locale setting
(see LC_COLLATE in particular).
A lot of locales have weird and wonderful rules that embody some
Oliveiros
- Original Message -
From: "Adrian Klaver"
To:
Cc: "Oliveiros C,"
Sent: Wednesday, October 14, 2009 9:54 PM
Subject: Re: [SQL] How to order varchar data by word
On Wednesday 14 October 2009 7:13:22 am Oliveiros C, wrote:
Hello, list.
I have a table wi
On Wednesday 14 October 2009 7:13:22 am Oliveiros C, wrote:
> Hello, list.
>
> I have a table with a varchar field that I would like to order by word, not
> by ordinal, which seems to be the default on postgres.
>
> Does anyone have a clue on how this can be done?
>
> Many thanx in advance,
>
> Be
Hello, list.
I have a table with a varchar field that I would like to order by word, not by
ordinal, which seems to be the default on postgres.
Does anyone have a clue on how this can be done?
Many thanx in advance,
Best,
Oliveiros
