Re: hash_array_extended() needs to pass down collation

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2020-11-03T10:48:54Z

Lists: pgsql-hackers

On Mon, Nov 02, 2020 at 10:01:53AM -0500, Tom Lane wrote:
> Peter Eisentraut <peter.eisentraut@enterprisedb.com> writes:
>> I noticed that hash_array_extended() does not pass down the collation to 
>> the element's collation function, unlike hash_array().  As a 
>> consequence, hash partitioning using text arrays as partition key fails.
> 
>> The attached patch fixes this.  I propose to backpatch this.
> 
> LGTM

+1.
--
Michael

Commits

Enable hash partitioning of text arrays
- ea9087938131 12.5 landed
- 82d4a2a7d63e 13.1 landed
- 560564d3addc 14.0 landed
Collations with nondeterministic comparison
- 5e1963fb764e 12.0 cited