Re: Explicit deterministic COLLATE fails with pattern matchingoperations on column with non-deterministic collation

    Tom Lane wrote:

> I suspect that the 'en-US-ks-level2' ICU locale doesn't act as you
> think it does.

Indeed, because the syntax is tricky. The OP wants 'en-US-u-ks-level2'.
With 'en-US-ks-level2', the ks-level2 component is ignored and you
get a tertiary colstrength.

Or use 'en-US@colStrength=secondary' which is possibly more
readable and works with older versions of ICU.


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite