> FWIW, I tried to reproduce the OP's reported failure with pl_PL.UTF-8,
> but it seems to pass fine for me. This implies that that locale works
> differently on his Ubuntu box than my RHEL box, which makes the idea
> of trying to guarantee that it works even more problematic.
It works on my computer too:
> hasegeli=# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "en_US";
> ?column?
> ----------
> t
> (1 row)
But not on my Debian box:
> debian=# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "en_US";
> ?column?
> ----------
> f
> (1 row)
It is fine with COLLATE "C":
> debian =# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "C";
> ?column?
> ----------
> t
> (1 row)
I suggest the attached.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs