sort order - Mailing list pgsql-general

From Abraham, Danny
Subject sort order
Date
Msg-id 2C0926ABD16BB641A8E2F11A5492004229B72C9BE0@PHXCCRPRD01.adprod.bmc.com
Whole thread Raw
Responses Re: sort order
List pgsql-general

On PG 9.0.4, Windows, Encoding and Collate WIN1252  trying to get a database to sort according to the ascii order.

Example:

Select t from test order by t

Should be exactly like

Select t from test order by ascii(t).

 

Can it be done? How?

 

Thanks

 

Danny

               

pgsql-general by date:

Previous
From: Andrew Armstrong
Date:
Subject: Improve replication usability
Next
From: "Abraham, Danny"
Date:
Subject: initdb locale WIN1252