Re: default locale considered harmful? (was Re: [GENERAL]

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

In response to

Responses

Browse pgsql-general by date

  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?

Browse pgsql-hackers by date

  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