show_trgm is still affected with the same issue:

CREATE EXTENSION IF NOT EXISTS pg_trgm;
CREATE TEMP TABLE st_a(x text COLLATE "C");     INSERT INTO st_a
VALUES ('hello');
CREATE TEMP TABLE st_b(y text COLLATE "POSIX"); INSERT INTO st_b
VALUES ('world');
SELECT show_trgm(x || y) FROM st_a, st_b;

And I noticed one more thing, is this change expected, as it doesn't
seem intentional? (also with posix or ucs_basic)

SELECT show_trgm('Привет мир' COLLATE "C");
-- {}

postgres=# SELECT similarity('Привет мир' COLLATE "C", 'Привет мир'
COLLATE "C");
-- 0

Looking back this is caused by 0002, and was there since v2 and I
completely missed it before.


Reply via email to