On Mon, Dec 15, 2008 at 10:19 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Well, one thing you should try is > > select 'wieck'::text < 'wiech'::text; > select 'wieck'::text > 'wiech'::text; >
administra...@casanova10 ~/pg.build/8.4dev $ bin/psql -a -f test.sql postgres select 'wieck'::text < 'wiech'::text; ?column? ---------- t (1 row) select 'wiech'::text < 'wieck'::text; ?column? ---------- f (1 row) > just to confirm whether the comparisons are actually working that way > or we've got some other issue. ok, confirmed... > You could also try initdb'ing in other > locales to see if the behavior changes. > Actually, using Spanish_Ecuador.1252 (wich is the one a i should use from the beginning anyway ;) gives correct results, maybe the other behaviour is correct in spain... we have a lot of spanish languages ;) administra...@casanova10 ~/pg.build/8.4dev $ bin/psql -a -f test.sql postgres select 'wieck'::text < 'wiech'::text; ?column? ---------- f (1 row) select 'wiech'::text < 'wieck'::text; ?column? ---------- t (1 row) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
