Re: JSON path decimal literal syntax - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: JSON path decimal literal syntax
Date
Msg-id eb5330c4-beee-0c7f-5ba1-2bab099c6e11@enterprisedb.com
Whole thread Raw
In response to JSON path decimal literal syntax  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: JSON path decimal literal syntax
List pgsql-hackers
On 18.02.22 11:17, Peter Eisentraut wrote:
> I noticed that the JSON path lexer does not support the decimal literal 
> syntax forms
> 
> .1
> 1.
> 
> (that is, there are no digits before or after the decimal point).  This 
> is allowed by the relevant ECMAScript standard 
> (https://262.ecma-international.org/5.1/#sec-7.8.3) and of course SQL 
> allows it as well.
> 
> Is there a reason for this?  I didn't find any code comments or 
> documentation about this.

It has come to my attention that there are syntactic differences between 
JavaScript, which is what JSON path is built on, and JSON itself. 
Presumably, the JSON path lexer was originally built with the JSON 
syntax in mind.

Attached is an updated patch that implements the JavaScript-based JSON 
path numeric literal syntax more correctly.  Besides the above mentioned 
syntax forms, it now also rejects trailing junk after numeric literals 
more correctly, similar to how the main SQL lexer does it.
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: fix crash with Python 3.11
Next
From: Nitin Jadhav
Date:
Subject: Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)