Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1oyhyo-000675-9p
	for pgsql-bugs@arkaria.postgresql.org; Fri, 25 Nov 2022 23:19:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1oyhyl-000313-Cm
	for pgsql-bugs@arkaria.postgresql.org; Fri, 25 Nov 2022 23:19:31 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vik@postgresfriends.org>)
	id 1oyhyl-0002zs-4U
	for pgsql-bugs@lists.postgresql.org; Fri, 25 Nov 2022 23:19:31 +0000
Received: from relay3-d.mail.gandi.net ([2001:4b98:dc4:8::223])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vik@postgresfriends.org>)
	id 1oyhyi-0005pE-Su
	for pgsql-bugs@lists.postgresql.org; Fri, 25 Nov 2022 23:19:30 +0000
Received: (Authenticated sender: vik@postgresfriends.org)
	by mail.gandi.net (Postfix) with ESMTPSA id 6DE5360005;
	Fri, 25 Nov 2022 23:19:23 +0000 (UTC)
Message-ID: <aca6e217-bffb-844c-ab63-98d032dbc732@postgresfriends.org>
Date: Sat, 26 Nov 2022 00:19:23 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: Inaccurate documentation about identifiers
Content-Language: en-US
To: raf <raf@raf.org>, pgsql-bugs@lists.postgresql.org
References: <feb15ca0-f449-c862-9414-66220e80304d@umanwizard.com>
 <efcd5fee059c8868ca47525a8cfdc8f42cf95fdc.camel@j-davis.com>
 <1954348.1668715270@sss.pgh.pa.us> <Y3a6BMoEzbcZ0rEy@raf.org>
From: Vik Fearing <vik@postgresfriends.org>
In-Reply-To: <Y3a6BMoEzbcZ0rEy@raf.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/aca6e217-bffb-844c-ab63-98d032dbc732%40postgresfriends.org>
Precedence: bulk

On 11/17/22 23:47, raf wrote:
> On Thu, Nov 17, 2022 at 03:01:10PM -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
>> ident_start		[A-Za-z\200-\377_]
>> ident_cont		[A-Za-z\200-\377_0-9\$]
>>
>> identifier		{ident_start}{ident_cont}*
> 
> Does the SQL spec require accepting *only* real letters as letters,
> or does it require accepting *at least* real letters as letters. :-)
> Just a bit of wishful thinking.

<identifier body> ::=
   <identifier start> [ <identifier part>... ]

<identifier part> ::=
     <identifier start>
   | <identifier extend>

An <identifier start> is any character in the Unicode General Category 
classes “Lu”, “Ll”, “Lt”, “Lm”, “Lo”, or “Nl”.

An <identifier extend> is U+00B7, “Middle Dot”, or any character in the 
Unicode General Category classes “Mn”, “Mc”, “Nd”, or “Pc”.
-- 
Vik Fearing