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 CACykOPQ+JvBwHLA_TZi6=V0+y+_CgGtb8i9zfLFkOexwsGpexA@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
Hello,

I have a question about nondeterministic collations.  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: Stan Brown
Date:
Subject: Re: A question about sequences and backup/restore cycles
Next
From: Michael Lewis
Date:
Subject: Re: Primary key definition?