Pierre LEBRECH <pierre.lebrech@xxxxxxxxxxx> writes: > I want to sort strings containing a dot but by taking care of this dot > like any other character. I suspect what you really want is C locale, and what you've got is some other locale that uses "dictionary" sort rules. Try "show lc_collate". regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general