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

2019-10-24 Thread Jeff Lanzarotta
Daniel, thanks for the reply. I believe we will just remove the collation, allow LIKE to function normally, and wait for a future patch is one is ever provided. On Thu, Oct 24, 2019 at 3:39 PM Daniel Verite wrote: > Jeff Lanzarotta wrote: > > > I have a question about nond

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

2019-10-24 Thread Jeff Lanzarotta
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

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

2019-10-22 Thread Jeff Lanzarotta
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: nondet