Thanks a lot. Worked fine with .....
CREATE DATABASE danny Template template0 LC_CTYPE = 'C' LC_COLLATE = 'C'; -----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: Monday, December 12, 2011 6:07 PM To: Abraham, Danny Cc: Adrian Klaver; [email protected] Subject: Re: [GENERAL] sort order "Abraham, Danny" <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
