in the description of the ORDER BY clause (http://www.postgresql.org/docs/curre...ml#SQL-ORDERBY) it says:

"Character-string data is sorted according to the locale-specific collation order that was established when the database was created."

Which is no longer true with 9.1 as it is possible to define the collation on a per-column basis or as part of the ORDER BY clause.

I think a link to the collation chapter and a description on the "precedence" of the definitions should be added to that part.

Regards
Thomas




--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Thomas Kellerer <spam_eater (AT) gmx (DOT) net> writes:
Done, thanks for the report.

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs