collation problem on 9.1-beta1

From: Marc Cousin <cousinmarc(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: collation problem on 9.1-beta1
Date: 2011-05-11 18:47:43
Message-ID: 1305139670.25203.3.camel@marco-dalibo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I've been starting to work on a 'what's new in 9.1' like i did last
year, and am faced with what I feel is a bug, while building a demo case
for collation.

Here it is:

SELECT * from (values ('llegar'),('llorer'),('lugar')) as tmp
order by 1 collate "es_ES.utf8";
ERROR: collations are not supported by type integer at character 74
STATEMENT: SELECT * from (values ('llegar'),('llorer'),('lugar')) as
tmp
order by 1 collate "es_ES.utf8";
^
marc=# SELECT * from (values ('llegar'),('llorer'),('lugar')) as tmp
order by column1 collate "es_ES.utf8";
column1
---------
llegar
llorer
lugar
(3 rows)

Of course, without the collate keyword, the «order by 1» works as usual.

Regards

Marc

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2011-05-11 18:57:09 Re: Changed behaviour of \'
Previous Message Tom Lane 2011-05-11 18:27:41 Re: BUG #6020: Wrong data type returned after CAST in FROM