On Mon, Feb 9, 2015 at 3:07 AM, David Evans <david.evans@cantab.net> wrote:
> On 9 February 2015 at 03:57, Gavin Flower <GavinFlower@archidevsys.co.nz>
> wrote:
>>
>> Would using jsonb be more consistent?
>
>
> Yes, casting to jsonb seems produce consistent output:
>
> # SELECT array_to_json(array[1, 2, 3])::jsonb, json_build_array(1, 2,
> 3)::jsonb;
> array_to_json | json_build_array
> ---------------+------------------
> [1, 2, 3] | [1, 2, 3]
>
> That makes sense I suppose, given that only the structure in preserved in
> the jsonb representation.
This is not really due to whitespace/'structure only' preservation
aspects of json and jsonb, respectively. What is happening here is
that the various functions that render json from text are non
consistent in terms of spacing. Personally, I greatly prefer the
xxx_to_json functions because they don't insert spurious whitespace
making for more compact documents; putting in spaces for aesthetic
purposes is the job for a prettifier.
merlin