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