doc: Fix description of deterministic flag of CREATE COLLATION

Peter Eisentraut <peter@eisentraut.org>

Commit: 4b451fd31d97dce66046aed89ecbece4f9c63edb
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2024-05-02T06:23:35Z
Releases: 12.19
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

Files

PathChange+/−
doc/src/sgml/ref/create_collation.sgml modified +1 −1

Documentation touched

Discussion