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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiroshi Saito 2011-12-10 15:13:09 Re: About Wince App
Previous Message John R Pierce 2011-12-09 20:49:51 Re: About Wince App