Ian Barwick <barwick@gmx.net> writes:
> The short answer is "no" (I am happy to be proven wrong of course ;-).
> As far as PostgreSQL is concerned, the locale used to determine sorting
> order is predefined at initdb and can't be changed dynamically.
> I don't know what the SQL standards say about this.
The SQL spec envisions attaching a locale specification to each
individual column. We don't support that ... yet. (There's been
a good deal of talk about it, and we'd like to handle it someday.)
At present, Ian is right: initdb determines the sort order for the
database cluster it creates.
regards, tom lane