From: | Yury Don <yura(at)vpcit(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #2309: Wrong string comparison |
Date: | 2006-03-10 07:57:30 |
Message-ID: | 200603101257.30717.yura@vpcit.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Friday 10 March 2006 12:36, Volkan YAZICI wrote:
> Hi,
>
> On Mar 09 02:00, Yury Don wrote:
> > Looks like string comparison operators ignore spaces isnside of string.
> > Because of this sorting on text fields is wrong.
> >
> > mdb=# select 'a z'::text>'ad'::text;
> > ?column?
> > ----------
> > t
>
> PostgreSQL relies on your locale for collation. Therefore, first you
> need to check if your locale settings are working. For instance:
>
> $ TEXT="a z\nad"
> $ echo -e $TEXT | LC_COLLATE=tr_TR.iso88599 sort
> ad
> a z
> $ echo -e $TEXT | LC_COLLATE=C sort
> a z
> ad
>
>
> Regards.
>
My locale is KOI8-R and sorting in PostgreSQL corresponds to sorting in
locale. I just didn't expect that sorting will be this way ...
--
Best regards,
Yury Don
From | Date | Subject | |
---|---|---|---|
Next Message | Kamil Giza | 2006-03-10 14:43:30 | Re: BUG #2307: Buckup and sequences in DEFAULT part |
Previous Message | Volkan YAZICI | 2006-03-10 07:36:11 | Re: BUG #2309: Wrong string comparison |