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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
