Re: 16beta2 SQL parser: different defaults on absent_on_null - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: 16beta2 SQL parser: different defaults on absent_on_null
Date
Msg-id 302258BE-ADAD-4884-9C30-F6243A156376@yesql.se
Whole thread Raw
In response to 16beta2 SQL parser: different defaults on absent_on_null  (Martin Butter <martin.butter@splendiddata.com>)
Responses Re: 16beta2 SQL parser: different defaults on absent_on_null
List pgsql-hackers
> On 14 Jul 2023, at 07:53, Martin Butter <martin.butter@splendiddata.com> wrote:

> While adapting a Java implementation of the SQL parser, I noticed that in structures JsonArrayAgg,
JsonArrayConstructor,JsonArrayQueryConstructor and JsonObjectConstrutor, the absent_on_null field defaults to TRUE. 
> But in JsonObjectAgg, absent_on_null defaults to FALSE.
> Is that intentionally?

I would say so, an empty NULL|ABSENT ON NULL clause for arrays is defined as
true, while for objects it's defined as false (which is shared between both
json_object() and json_objectagg()).

--
Daniel Gustafsson




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Remove distprep
Next
From: Daniel Gustafsson
Date:
Subject: Re: DROP DATABASE is interruptible