From: | "Russ Brown" <pickscrape(at)gmail(dot)com> |
---|---|
To: | "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: is this a bug or I am blind? |
Date: | 2005-12-16 18:19:38 |
Message-ID: | op.s1v2i0hp2ilifp@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 16 Dec 2005 11:59:48 -0600, Csaba Nagy <nagy(at)ecircle-ag(dot)com> wrote:
> On Fri, 2005-12-16 at 18:52, Tom Lane wrote:
>> Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
>> > ... So "tyty" and "tty" could be arguably both taken as double "ty",
>> > except that the official form is "tty"... but from a pronunciation
>> point
>> > of view they ARE equivalent in hungarian.
>>
>> That's fair enough, but the question is should they be taken as
>> equivalent for string-comparison purposes? (English has plenty of
>> cases where different letter combinations sound alike, but we don't
>> consider them equal because of that. That may not be a good analogy
>> though. Also, if there are cases in other locales where strcoll
>> considers non-identical strings equal, the reasoning for it might be
>> quite different.)
>
> Well, I'm not an expert on this one. In any case, hungarian has
> phonetical writing as opposed to the etymological writing English has.
> So in hungarian there is a 1 to 1 mapping between the sounds and the
> signs used to depict them... so pronunciation is somewhat more relevant
> in sorting I guess. But I'm not a linguist so I won't know for sure.
>
Trouble is, you can never guarantee that you're dealing with actual words.
What of you're comparing someone's password that happens to contain
combination of letters that act in this way?
> Cheers,
> Csaba.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
--
Russ
From | Date | Subject | |
---|---|---|---|
Next Message | Ale Raza | 2005-12-16 18:25:21 | Re: Debug user lib for user define data type |
Previous Message | Martijn van Oosterhout | 2005-12-16 18:19:17 | Re: is this a bug or I am blind? |