doc: Fix description of deterministic flag of CREATE COLLATION
authorPeter Eisentraut <peter@eisentraut.org>
Thu, 2 May 2024 06:21:18 +0000 (08:21 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Thu, 2 May 2024 06:21:18 +0000 (08:21 +0200)
commit4a65e1c21290f15a1b5996eeb4700af034844ebd
tree976dde38e3235cc61bb639a08f17f9e58c2c2e64
parent9c1d1bde4487a40e963a9571ee44c90deea71f82
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