Postgres Pro
Downloads
Home   >   mailing lists

could not determine which collation to use for string comparison - Mailing list pgsql-bugs

From Andrey
Subject could not determine which collation to use for string comparison
Date
Msg-id CAOYf6ee5Jfbgn_524rW0ESPfKc7vD_gwO6KCmwd7_kcwwC5WCQ@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: BUG #15001: planner cann't distinguish composite index?
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] BUG #14860: pg_read_all_stats and pg_stat_replication