Support POSITION with nondeterministic collations

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Support POSITION with nondeterministic collations
Date: 2024-08-26 06:09:19
Message-ID: 582b2613-0900-48ca-8b0d-340c06f4d400@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This patch allows using text position search functions with
nondeterministic collations. These functions are

- position, strpos
- replace
- split_part
- string_to_array
- string_to_table

which all use common internal infrastructure.

(This complements the patch "Support LIKE with nondeterministic
collations" but is independent.)

Some exploratory testing could be useful here. The present test
coverage was already quite helpful during development, but there is
always the possibility that something was overlooked.

Attachment Content-Type Size
v1-0001-Support-POSITION-with-nondeterministic-collations.patch text/plain 15.4 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2024-08-26 06:14:05 Re: Introduce XID age and inactive timeout based replication slot invalidation
Previous Message Thomas Munro 2024-08-26 05:54:26 Re: macOS prefetching support