This is exactly what I am trying to do - To find a CREATE DATABASE statement that will produce a database that has a binary sorting. Thanks Danny -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Monday, December 12, 2011 5:53 PM To: pgsql-general@xxxxxxxxxxxxxx Cc: Abraham, Danny Subject: Re: sort order On Sunday, December 11, 2011 8:17:41 am Abraham, Danny wrote: > 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? Not after a database has been created. For more info see: http://www.postgresql.org/docs/9.0/interactive/locale.html In particular LC_COLLATE. > > Thanks > > Danny -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
