Re: Support LIKE with nondeterministic collations

On 30.04.24 14:39, Daniel Verite wrote:
>    postgres=# SELECT '.foo.' like '_oo' COLLATE ign_punct;
>     ?column?
>    ----------
>     f
>    (1 row)
> 
> The first two results look fine, but the next one is inconsistent.

This is correct, because '_' means "any single character".  This is 
independent of the collation.

I think with nondeterministic collations, the single-character wildcard 
is often not going to be all that useful.