could not determine which collation to use for string comparison

From: Andrey <parihaaraka(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: could not determine which collation to use for string comparison
Date: 2018-01-10 14:05:15
Message-ID: CAOYf6ee5Jfbgn_524rW0ESPfKc7vD_gwO6KCmwd7_kcwwC5WCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello.
PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10)
4.9.2, 64-bit

select *
from (select 'test'::text collate "C" id) c1
full join (select 'test'::text collate "en_US" id) c2 on
-- c1.id = c2.id ----< ok
c1 = c2

ERROR: could not determine which collation to use for string comparison
SQLSTATE: 42P22

Records comparison does not work if corresponding fields have different
collation.

Browse pgsql-bugs by date

  From Date Subject
Next Message Bossart, Nathan 2018-01-10 17:26:43 Re: BUG #14941: Vacuum crashes
Previous Message Amit Kapila 2018-01-10 03:35:19 Re: BUG #15001: planner cann't distinguish composite index?