Re: hash_array_extended() needs to pass down collation

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

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

To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2020-11-02T15:01:53Z

Lists: pgsql-hackers

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

			regards, tom lane

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