Search Postgresql Archives

Stability of JSON textual representation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux