diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2024-05-02 08:21:18 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2024-05-02 08:21:18 +0200 |
| commit | 4a65e1c21290f15a1b5996eeb4700af034844ebd (patch) | |
| tree | 976dde38e3235cc61bb639a08f17f9e58c2c2e64 /doc/src | |
| parent | 9c1d1bde4487a40e963a9571ee44c90deea71f82 (diff) | |
| download | postgresql-4a65e1c21290f15a1b5996eeb4700af034844ebd.tar.gz postgresql-4a65e1c21290f15a1b5996eeb4700af034844ebd.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_collation.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_collation.sgml b/doc/src/sgml/ref/create_collation.sgml index 85f18cbbe5d..e34bfc97c3d 100644 --- a/doc/src/sgml/ref/create_collation.sgml +++ b/doc/src/sgml/ref/create_collation.sgml @@ -154,7 +154,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> |