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?
> > --
>
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, firs
"Yury Don" <[EMAIL PROTECTED]> writes:
> Looks like string comparison operators ignore spaces isnside of string.
It's not wrong, it's just following the rules of the locale. You should
initdb the database with LANG=C if you want plain ASCII sorting.
regards, tom lane
---
The following bug has been logged online:
Bug reference: 2309
Logged by: Yury Don
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Linux (Debian)
Description:Wrong string comparison
Details:
Looks like string comparison operators ignore s
