How to obtain a good ASCII order ?

From: eurlix <eurlix(at)libertysurf(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to obtain a good ASCII order ?
Date: 2003-05-28 19:38:21
Message-ID: 20030528213821.2490c707.eurlix@libertysurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-05-28 19:47:10 Re: Inserting data of two other tables [Now deleting ...]
Previous Message papapep 2003-05-28 16:59:08 Re: Inserting data of two other tables [Now deleting ...]