Re: SQL:2023 JSON simplified accessor support

> On Sep 2, 2025, at 11:53, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Monday, September 1, 2025, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com <mailto:li(dot)evan(dot)chao(at)gmail(dot)com>> wrote:
>>
>> The last comment is about error message:
>>
>> ```
>> evantest=# select data.a from test_jsonb_types;
>> ERROR: missing FROM-clause entry for table "data"
>> LINE 1: select data.a from test_jsonb_types;
>> ```
>>
>> “Missing FROM-clause entry” is quite confusing and not providing much useful hint to resolve the problem. When I first saw this error, I was stuck. Only after read through the commit comments, I figured out the problem. For end users, we should provide some more meaningful error messages.
>>
>
> I don’t think it’s fair to blame this patch set for this. If you want to reference a component of a composite column you need to write ([tbl.]col).field otherwise the parser gets confused because it wants the thing prior to “field” to be a table name if you don’t use the parentheses. This comes up all the time if one uses composite typed columns. I’ll agree this isn’t the greatest error message but I’d suggest starting a new thread if you want to see about improving it.
>
> David J.
>

Sure, we can discuss the topic separately.

--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/