On 9 February 2015 at 03:57, Gavin Flower <gavinflo...@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. Thanks! I should have thought of that myself. Dave