Folding of case of identifiers

Поиск
Список
Период
Сортировка
От Niels Jespersen
Тема Folding of case of identifiers
Дата
Msg-id d46916d0e9e84f66b158be52e5c4ad3a@dst.dk
обсуждение исходный текст
Ответы Re: Folding of case of identifiers
Список pgsql-general
Hello all

According to https://www.postgresql.org/docs/current/sql-syntax-lexical.html, "Key words and unquoted identifiers are
caseinsensitive." And "SQL identifiers and key words must begin with a letter (a-z, but also letters with diacritical
marksand non-Latin letters) or an underscore (_). Subsequent characters in an identifier or key word can be letters,
underscores,digits (0-9), or dollar signs ($)." 

So far so good. Non-latin letters are included, which I take to also include the danish letters æøå/ÆØÅ.

However, name-folding is odd for these letters. Of these three create tables, the two first succeed, the last one does
not(G and g is equivalent, Æ and æ is not).  

create table æblegrød (a int, køn text);
create table ÆblegrØd (a int, køn text);
create table ÆbleGrØd (a int, køn text);

Can anyone explain the logic that rules this.

Regards Niels Jespersen






В списке pgsql-general по дате отправления:

Предыдущее
От: Wolfgang Walther
Дата:
Сообщение: Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory