How to obtain a good ASCII order ? - Mailing list pgsql-novice

From eurlix
Subject How to obtain a good ASCII order ?
Date
Msg-id 20030528213821.2490c707.eurlix@libertysurf.fr
Whole thread Raw
List pgsql-novice
Hello all,

It seem to me that when a column contain non current characters
like "*" (052, X2A), ">" (076, X3E), etc ... pg gives it in a
non-ASCII ordered sequence.

When I know that some character may be appear volontary in the
first position of the column, I have found that I can have a good
result (for me) by "... order by substr(col,1,1), col ...) but
when I cannot presume this, how may I have a good sequence ?

Thanks,
--
Alain Lucari (Eurlix)

pgsql-novice by date:

Previous
From: papapep
Date:
Subject: Re: Inserting data of two other tables [Now deleting ...]
Next
From: Nabil Sayegh
Date:
Subject: Re: Inserting data of two other tables [Now deleting ...]