Re: Fwd: [BUGS] BUG #1972: index error with space character

2005-10-18 Thread Tom Lane
Eduardo RBS <[EMAIL PROTECTED]> writes: > I need a locate that not ignores the space chracater and also sort > accents like á or ã. I'm afraid you'll have to learn how to build your own locale definition. AFAIK, the "C" locale is the *only* common locale in which spaces aren't second-class citizen

Fwd: [BUGS] BUG #1972: index error with space character

2005-10-18 Thread Eduardo RBS
-- Forwarded message -- From: Eduardo RBS <[EMAIL PROTECTED]> Date: 18/10/2005 13:31 Subject: Re: [BUGS] BUG #1972: index error with space character To: Richard Huxton Hellow.. Thank you very much for the attention. I need a locate that not ignores the space chracater an

Re: [BUGS] BUG #1972: index error with space character

2005-10-18 Thread Richard Huxton
Eduardo Soares wrote: 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 "AZT

[BUGS] BUG #1972: index error with space character

2005-10-18 Thread Eduardo Soares
The following bug has been logged online: Bug reference: 1972 Logged by: Eduardo Soares Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux Fedora 4 Description:index error with space character Details: In above example the "AZTES Z" s