On Mon, Feb 9, 2015 at 3:07 AM, David Evans <david.ev...@cantab.net> wrote: > 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.
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
