BUG #6053: Can't do DISTINCT on citext column

From: "Regina" <lr(at)pcorp(dot)us>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6053: Can't do DISTINCT on citext column
Date: 2011-06-05 19:22:07
Message-ID: 201106051922.p55JM7RF016044@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: 6053
Logged by: Regina
Email address: lr(at)pcorp(dot)us
PostgreSQL version: 9.1beta1
Operating system: Windows
Description: Can't do DISTINCT on citext column
Details:

I have a table I created like this:
-- With and without the COLLATE in there I get the same error.

CREATE TABLE test
(
fullname citext COLLATE pg_catalog."POSIX",
);

INSERT INTO test(fullname) VALUES('test1'),('test2');

When I do a:
SELECT DISTINCT fullname FROM test;

or a

SELECT DISTINCT fullname COLLATE pg_catalog."POSIX" FROM test;

It gives error:

ERROR: could not determine which collation to use for lower() function
HINT: Use the COLLATE clause to set the collation explicitly.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2011-06-06 10:22:36 Re: BUG #6052: ADD COLUMN - ERROR: tables can have at most 1600 columns
Previous Message Tom Lane 2011-06-04 21:24:22 Re: BUG #6051: wCTE query fail with wrong error text on a table with rules