Re: 16beta2 SQL parser: different defaults on absent_on_null

2023-07-14 Thread Martin Butter
Hello Daniel, Thanks for the explanation, it sounds reasonable. I'm glad it is not a bug. Regards, Martin. On 14/07/2023 10:29, Daniel Gustafsson wrote: On 14 Jul 2023, at 07:53, Martin Butter wrote: While adapting a Java implementation of the SQL parser, I noticed that in struc

16beta2 SQL parser: different defaults on absent_on_null

2023-07-13 Thread Martin Butter
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?

=> operator for named parameters in open cursor

2022-06-08 Thread Martin Butter
Since Postgres 9.5 it is possible to use the => operators for filling in named parameters in a function call, like perform my_func(named_param => 'some value'). The old form, with the := operator is still allowed for backward reference. But with open cursor, still only the old := operator is a