Postgres Pro
Downloads
Home   >   mailing lists

SQL Error [0A000]: ERROR: nondeterministic collations are notsupported for LIKE - Mailing list pgsql-general

From Jeff Lanzarotta
Subject SQL Error [0A000]: ERROR: nondeterministic collations are notsupported for LIKE
Date
Msg-id CACykOPQKHGRLzuAB1Mvn9Pizatp9g=JG_CHYxn4VOD+D7E4Vcg@mail.gmail.com
Whole thread Raw
Responses Re: SQL Error [0A000]: ERROR: nondeterministic collations are not supported for LIKE
List pgsql-general
Tree view
Hello,

Not sure if my original email was actually received or not.  If it was, forgive the repost...

I have a question about nondeterministic collations in PostgreSQL 12.  I have created a new collation that is nondeterministic and created several columns which use this collation.  Querying these columns works great until I use LIKE.  When I do, I get the following error:

SQL Error [0A000]: ERROR: nondeterministic collations are not supported for LIKE

Is there any plan to allow this functionality?

Thanks,

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Having more than one constraint trigger on a table
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Having more than one constraint trigger on a table