sort order

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: sort order
Date: 2011-12-11 16:17:41
Message-ID: 2C0926ABD16BB641A8E2F11A5492004229B72C9BE0@PHXCCRPRD01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2011-12-11 16:30:35 initdb locale WIN1252
Previous Message Greg Smith 2011-12-11 06:19:07 Re: Hope for a new PostgreSQL era?