Skip site navigation (1) Skip section navigation (2)

Re: Documentation bug regarding collations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Documentation bug regarding collations
Date: 2012-01-29 01:56:42
Message-ID: 11554.1327802202@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> in the description of the ORDER BY clause (http://www.postgresql.org/docs/current/static/sql-select.html#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.

Done, thanks for the report.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-01-29 02:08:26
Subject: Re: Example in plpgsql docs can lead to infinite loop
Previous:From: Michael BrauwermanDate: 2012-01-29 01:45:00
Subject: Re: BUG #6200: standby bad memory allocations on SELECT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group