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

Re: Fwd: BUG #1972: index error with space character

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eduardo RBS <edurbs(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Fwd: BUG #1972: index error with space character
Date: 2005-10-19 02:16:54
Message-ID: 16415.1129688214@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Eduardo RBS <edurbs(at)gmail(dot)com> 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 citizens.

I know that it is possible to write your own locale definition, but
this is not the place to ask about how.  Try a glibc support forum.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Stanislav SukholetDate: 2005-10-19 02:31:30
Subject: BUG #1976: steps to reproduce BUG #1438: Non UTF-8 client encoding problem
Previous:From: Anand KumriaDate: 2005-10-18 22:45:25
Subject: SIGSEGV in Postgres 8.0.3 (libpq4)

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