Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC callsvery much - Mailing list pgsql-bugs

From Dmitry Dolgov
Subject Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC callsvery much
Date
Msg-id CA+q6zcUyiqG8HezQT2U+78udtMPeOFiXD9dRmT5saYtESckOpw@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC callsvery much  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC callsvery much
List pgsql-bugs
> On 13 October 2017 at 15:48, Michael Paquier <michael.paquier@gmail.com> wrote:
>
> it is perfectly valid to have something like json_build_array('2', NULL) or
> json_build_object('1', NULL), because there can be NULL values in JSON
> strings. What we just need to be careful here is to check if the array
> is NULL or not in a variadic call, and just return NULL in this case.

Oh, indeed, I agree.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC callsvery much
Next
From: edpeur@gmail.com
Date:
Subject: [BUGS] BUG #14853: Parameter type is required even when the query does notneed to know the type