Re: Duplicate Values or Not?!

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, John Seberg <johnseberg(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Duplicate Values or Not?!
Date: 2005-09-17 14:51:10
Message-ID: 87ll1vrbmp.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> If that does change the results, it indicates you've got strings which
> are bytewise different but compare equal according to strcoll(). We've
> seen this and other misbehaviors from some locale definitions when faced
> with data that is invalid per the encoding the locale expects.

There are plenty of non-bytewise-identical strings that do legitimately
compare equal in various locales. Does the hash code hash strxfrm or the
original bytes?

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2005-09-17 15:50:44 Re: Duplicate Values or Not?!
Previous Message Tom Lane 2005-09-17 14:22:42 Re: Duplicate Values or Not?!