postgresql - Postgres 字符串比较特性

Question

谁能解释下面的矛盾？

select 'b.0'<'b00.0';
 ?column?
----------
 t

但是

select 'b.g'<'b00.g';
 ?column?
----------
 f

Answer 1

那是一个collation issue .尝试

select '.0' < '00', '.9' < '00', '.9' < '00' collate "C";
 ?column? | ?column? | ?column? 
----------+----------+----------
 t        | f        | t

http://wiki.postgresql.org/wiki/Todo:ICU