To make a long story short, few years ago I was complaining that the sort order
of varchar, in UTF-8, was ignoring blanks, that is that the sort order was:
a
a
A
A
à
b
B
But, i was in need of a sort order that would place blanks BEFORE the other
char, that is I wou
On Sunday 20 January 2008 01:07, Tom Lane wrote:
> "Luca Arzeni" <[EMAIL PROTECTED]> writes:
> > Is there any way to consider blanks meaningfull AND sort properly locale
> > specific vowels ?
>
> This isn't a Postgres question, it's a locale question.
On Jan 15, 2008 6:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Luca Arzeni <[EMAIL PROTECTED]> writes:
> > That is: the sort order in postgres 8.1.9 seems to ignore the blank.
>
> This is expected behavior in most non-C locales.
>
> > In all cases I'm usin
On Jan 15, 2008 6:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>>Luca Arzeni <[EMAIL PROTECTED]> writes:
>> That is: the sort order in postgres 8.1.9 seems to ignore the blank.
>
>This is expected behavior in most non-C loca
Y KEY (c_column)
)
WITHOUT OIDS;
INSERT INTO t_table(c_column) VALUES (' A');
INSERT INTO t_table(c_column) VALUES ('B');
INSERT INTO t_table(c_column) VALUES (' C');
select * from t_table order by c_column asc;
=
Thanks, Luca Arzeni
-
Y KEY (c_column)
)
WITHOUT OIDS;
INSERT INTO t_table(c_column) VALUES (' A');
INSERT INTO t_table(c_column) VALUES ('B');
INSERT INTO t_table(c_column) VALUES (' C');
select * from t_table order by c_column asc;
=
Thanks, Luca Arzeni
-