postgres.git / summary / log / commit / refs

commit    4b451fd31d97dce66046aed89ecbece4f9c63edb
Author:   Peter Eisentraut <peter@eisentraut.org>
Date:     Thu May 02 06:21:18 2024 +0000
First released in: 17.0, 12.19, 13.15, 14.12, 15.7, 16.3

    doc: Fix description of deterministic flag of CREATE COLLATION
    
    The documentation said that you need to pick a suitable LC_COLLATE
    setting in addition to setting the DETERMINISTIC flag.  This would
    have been correct if the libc provider supported nondeterministic
    collations, but since it doesn't, you actually need to set the LOCALE
    option.
    
    Reviewed-by: Kashif Zeeshan <kashi.zeeshan@gmail.com>
    Discussion: https://www.postgresql.org/message-id/flat/a71023c2-0ae0-45ad-9688-cf3b93d0d65b%40eisentraut.org


 doc/src/sgml/ref/create_collation.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/ref/create_collation.sgml b/doc/src/sgml/ref/create_collation.sgml
index 58f5f0cd63a..11c00898518 100644
--- a/doc/src/sgml/ref/create_collation.sgml
+++ b/doc/src/sgml/ref/create_collation.sgml
@@ -139,7 +139,7 @@ CREATE COLLATION [ IF NOT EXISTS ] <replaceable>name</replaceable> FROM <replace
        logically equal by the comparison.  PostgreSQL breaks ties using a
        byte-wise comparison.  Comparison that is not deterministic can make the
        collation be, say, case- or accent-insensitive.  For that, you need to
-       choose an appropriate <literal>LC_COLLATE</literal> setting
+       choose an appropriate <literal>LOCALE</literal> setting
        <emphasis>and</emphasis> set the collation to not deterministic here.
       </para>
 


[parent: e3f9dcabd6f2]