Skip site navigation (1) Skip section navigation (2)

Re: LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Lumby <johnlumby(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...
Date: 2011-12-10 08:26:13
Message-ID: 20915.1323505573@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
John Lumby <johnlumby(at)hotmail(dot)com> writes:
> psql -d proteusdb -c "select count(*) from entity as e1 where ( e1.association_id IN ( select id from entity as e2 where e2.parent_id=3043508) OR e1.association_id=3043508 ) and e1.discriminator LIKE 'DEPLOY%'";
> ERROR: could not determine which collation to use for string comparison
> HINT: Use the COLLATE clause to set the collation explicitly.

FWIW, I tried to replicate this on the basis of the limited information
you gave, and could not.  Can you provide a self-contained test case?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Hiroshi SaitoDate: 2011-12-10 15:13:09
Subject: Re: About Wince App
Previous:From: John R PierceDate: 2011-12-09 20:49:51
Subject: Re: About Wince App

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group