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.