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.