JSON/SQL: jsonpath: incomprehensible error message - Mailing list pgsql-hackers

From Erik Rijkers
Subject JSON/SQL: jsonpath: incomprehensible error message
Date
Msg-id ba069ce2-a98f-dc70-dc17-2ccf2a9bf7c7@xs4all.nl
Whole thread Raw
Responses Re: JSON/SQL: jsonpath: incomprehensible error message
List pgsql-hackers
JSON/SQL jsonpath

For example, a jsonpath string with deliberate typo 'like_regexp' 
(instead of 'like_regex'):

select js
from (values (jsonb '{}')) as f(js)
where js @? '$ ? (@ like_regexp "^xxx")';

ERROR:  syntax error, unexpected IDENT_P at or near " " of jsonpath input
LINE 1: ...s from (values (jsonb '{}')) as f(js) where js @? '$ ? (@ li...
                                                              ^

Both  'IDENT_P'  and  'at or near " "'  seem pretty useless.

Perhaps some improvement can be thought of?

Similar messages in release 14 seem to use 'invalid token', which is better:

select js
from (values (jsonb '{"a":"b"}')) as f(js)
where js @? '$ ? (@.a .= "b")';
ERROR:  syntax error, unexpected invalid token at or near "=" of 
jsonpath input

thanks,
Erik Rijkers




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Core dump in range_table_mutator()
Next
From: Justin Pryzby
Date:
Subject: Re: Add LZ4 compression in pg_dump