On 9 February 2015 at 03:57, Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)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.
Thanks! I should have thought of that myself.
Dave