From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: fcaa@tragsa.es
Subject: In unquoted identifiers, only single-byte characters are always folded to lower case
Date: Fri, 23 Nov 2018 11:16:37 +0000
Message-ID: <154297179734.1320.17005240477883952460@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-syntax-lexical.html
Description:
Last paragraph on "4.1.1. Identifiers and Key Words" in the documentation
states:
1.- "[...] unquoted names are always folded to lower case"
2.- "If you want to write portable applications you are advised to always
quote a particular name or never quote it"
As said in response to bug #15516 (Identifier not quoted with uppercase
letter (spanish Ñ) doesn't get transformed to lowercase (ñ)) on
pgsql-bugs:
"PG's downcasing transform is only applied to single-byte characters.
So Ñ could be transformed in LATIN1 encoding, but not UTF8."
Given that, that paragraph should clarify this situation by:
1.- replacing "always folded to lower case" with "always folded to lower
case, except for multi-byte characters".
2.- adding another example about this. For instance, "But identifier AÑO
(using multi-byte character Ñ, Unicode U+00D1) is folded to aÑo."
3.- removing "or never quote it".
Regards,
Paco Calvo.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, fcaa@tragsa.es
Subject: Re: In unquoted identifiers, only single-byte characters are always folded to lower case
In-Reply-To: <154297179734.1320.17005240477883952460@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox