Re: Stability of JSON textual representation - Mailing list pgsql-general

On 03/02/15 00:06, David Evans wrote:
> I've noticed that when representing lists as JSON, Postgres 9.4
> sometimes outputs spaces after commas, and other times does not.
>
>     # SELECT array_to_json(array[1, 2, 3]), json_build_array(1, 2, 3);
>
>      array_to_json | json_build_array
>     ---------------+------------------
>      [1,2,3]       | [1, 2, 3]
>
>
> This matters to me because I'm intending the hash the JSON text and
> use the hash for change detection.
>
> This difference in behaviour doesn't seem to be documented anywhere.
> Does anyone know whether it is likely to be stable?
>
> Many thanks,
>
> Dave
  Would using jsonb be more consistent?


Cheers,
Gavin