Pierre LEBRECH wrote:
But I have found a solution which works : select name from (select distinct name from t) as name order by replace(name, '.', 'a');
Shouldn't you replace '.' with a character whose collating sequence is strictly less than 'a'? This solution looks to me as though it might not get ,e.g., 'coast' and 'co.st' in the desired order except by chance. -- Steve Wampler -- swampler@xxxxxxxx The gods that smiled on your birth are now laughing out loud. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
