,
Oliveiros
- Original Message -
From: Tom Lane t...@sss.pgh.pa.us
To: Oliveiros C, oliveiros.crist...@marktest.pt
Cc: Adrian Klaver akla...@comcast.net; pgsql-sql@postgresql.org
Sent: Monday, October 19, 2009 6:32 PM
Subject: Re: [SQL] How to order varchar data by word
Oliveiros C
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 give me a
- Original Message -
From: Adrian Klaver akla...@comcast.net
To: Oliveiros C, oliveiros.crist...@marktest.pt
Cc: Tom Lane t...@sss.pgh.pa.us; pgsql-sql@postgresql.org
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
Message -
From: Adrian Klaver akla...@comcast.net
To: pgsql-sql@postgresql.org
Cc: Oliveiros C, oliveiros.crist...@marktest.pt
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
Oliveiros C, oliveiros.crist...@marktest.pt 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
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
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,
Best,