Re: Duplicate Values or Not?! - Mailing list pgsql-general

From Greg Stark
Subject Re: Duplicate Values or Not?!
Date
Msg-id 87ll1vrbmp.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Duplicate Values or Not?!  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Duplicate Values or Not?!
Re: Duplicate Values or Not?!
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Duplicate Values or Not?!
Next
From: Greg Stark
Date:
Subject: Re: Duplicate Values or Not?!