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.
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 |