From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Andrew Sullivan <andrew(at)libertyrms(dot)info>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: default locale considered harmful? (was Re: [GENERAL] |
Date: | 2003-05-31 11:24:50 |
Message-ID: | Pine.LNX.4.44.0305311321550.6382-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Tom Lane writes:
> Peter has provided a hack whereby one can create a LIKE-supporting index
> in a non-C locale. But a *default* index in a non-C locale is still not
> going to support LIKE ... and the hacked index will not support ordinary
> comparison or ordering operators. So I think there's still a lot left
> to be desired here.
I don't understand why you call this a hack. Pattern matching and string
comparison simply work differently, so the proper solution is to use
different operator classes. After all, that's what operator classes exist
for. What is left to be desired?
--
Peter Eisentraut peter_e(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | bijoy | 2003-05-31 12:58:00 | psql: FATAL: Missing or erroneous pg_hba.conf file |
Previous Message | Justin Clift | 2003-05-31 07:39:34 | Re: [GENERAL] Are we losing momentum? |
From | Date | Subject | |
---|---|---|---|
Next Message | Rasmus Resen Amossen | 2003-05-31 11:34:49 | Postgres config file: autocommit = off |
Previous Message | Hannu Krosing | 2003-05-31 10:35:43 | Re: XML ouput for psql |