Re: using strxfrm for having multi locale/please vote for - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: using strxfrm for having multi locale/please vote for
Date
Msg-id 200506072040.26212.peter_e@gmx.net
Whole thread Raw
In response to Re: using strxfrm for having multi locale/please vote for  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian wrote:
> > Sounds like pie in the sky to me.  Exactly how do you think that
> > ICU will magically mask the fundamental semantic inconsistency?
>
> I am hoping ICU will allow us to see the next greatest value for that
> character.

As Tom says, it's a semantic inconsistency, not a lack of features.
Collation (sorting of strings) takes the entire string into account,
pattern matching compares character by character.  For example, some
collations compare strings from back to front, whereas a pattern
matching expression could never make sense of that.  The SQL standard
actually does not draw that distinction, but, well, it's broken.

Using separate operator classes for separate semantic interpretations of
data seems to be exactly the right solution.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-patches by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: SQLSTATE and SQLERRM
Next
From: Alvaro Herrera
Date:
Subject: Re: Are you actively hacking on 2PC?