Thread: Documentation bug regarding collations

in the description of the ORDER BY clause (http://www.postgresql.org/docs/current/static/sql-select.html#SQL-ORDERBY)
itsays: 

"Character-string data is sorted according to the locale-specific collation order that was established when the
databasewas 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
ORDERBY clause. 

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

Regards
Thomas

Thomas Kellerer <spam_eater@gmx.net> writes:
> in the description of the ORDER BY clause (http://www.postgresql.org/docs/current/static/sql-select.html#SQL-ORDERBY)
itsays: 
> "Character-string data is sorted according to the locale-specific collation order that was established when the
databasewas 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
ORDERBY clause. 

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

Done, thanks for the report.

            regards, tom lane