BUG #5970: intersect and collation on types

From: "Rikard Pavelic" <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5970: intersect and collation on types
Date: 2011-04-10 19:25:41
Message-ID: 201104101925.p3AJPfgp052349@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5970
Logged by: Rikard Pavelic
Email address: rikard(dot)pavelic(at)zg(dot)htnet(dot)hr
PostgreSQL version: 9.1.alpha5
Operating system: Windows XP SP3
Description: intersect and collation on types
Details:

create table test_collation (id int, name varchar);
insert into test_collation values (1, 'abc'), (2,'bcd');

--works
select * from test_collation tc
intersect
select * from test_collation tc;

--doesn't work
select tc from test_collation tc
intersect
select tc from test_collation tc;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Noah Misch 2011-04-10 21:38:49 Re: BUG #5856: pg_attribute.attinhcount is not correct.
Previous Message Robert Haas 2011-04-10 15:19:26 Re: BUG #5856: pg_attribute.attinhcount is not correct.