Skip site navigation (1) Skip section navigation (2)

BUG #1972: index error with space character

From: "Eduardo Soares" <edurbs(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1972: index error with space character
Date: 2005-10-17 17:00:21
Message-ID: 20051017170021.03FEBF12A4@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1972
Logged by:          Eduardo Soares
Email address:      edurbs(at)gmail(dot)com
PostgreSQL version: 8.0.3
Operating system:   Linux Fedora 4
Description:        index error with space character
Details: 

In above example the "AZTES Z" should be after the "AZTESA". It happens with
any encoding type. The DB not see the space character. The index shoulb see
the space and put "AZTES Z" together with "AZTES". In above list the
"AZTESA" should be the first.

Thanks for the help.

table=# insert into edu values ('AZTES Z');
INSERT 133634 1
table=# insert into edu values ('AZTESA');
INSERT 133635 1
table=# SELECT * FROM EDU ORDER BY NOME DESC;
     nome
---------------
 AZTES Z
 AZTESA
 AZTES
 NTES
 ANTES
(8 registros)

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-10-17 17:19:27
Subject: Re: [GENERAL] Postgres logs to syslog LOCAL0
Previous:From: Tom LaneDate: 2005-10-17 13:57:58
Subject: Re: [GENERAL] Postgres logs to syslog LOCAL0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group