Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much

From: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, Marko Tiikkaja <marko(at)joh(dot)to>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much
Date: 2017-10-13 13:56:45
Message-ID: CA+q6zcUyiqG8HezQT2U+78udtMPeOFiXD9dRmT5saYtESckOpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

> On 13 October 2017 at 15:48, Michael Paquier <michael(dot)paquier(at)gmail(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message edpeur 2017-10-13 14:03:50 BUG #14853: Parameter type is required even when the query does not need to know the type
Previous Message Michael Paquier 2017-10-13 13:48:09 Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2017-10-13 13:58:04 Re: v10 bottom-listed
Previous Message Victor Drobny 2017-10-13 13:55:12 Re: new function for tsquery creartion