Thanks a lot. Worked fine with ..... CREATE DATABASE danny Template template0 LC_CTYPE = 'C' LC_COLLATE = 'C'; -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Monday, December 12, 2011 6:07 PM To: Abraham, Danny Cc: Adrian Klaver; pgsql-general@xxxxxxxxxxxxxx Subject: Re: sort order "Abraham, Danny" <danny_abraham@xxxxxxx> writes: > 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. Setting its LC_COLLATE to "C" ought to do that. BTW, as of 9.1 you can control this at finer granularity than database level, see the COLLATE clause. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
