Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

I checked standard, and it looks like not a significant problem to implement it in Postgres. The implementation should be similar to XML - requires parser support. We doesn't use a identifier of important SQL/JSON functions: JSON_EXISTS, JSON_VALUE, JSON_QUERY, JSON_TABLE, JSON_ARRAY. The problem should be with function JSON_OBJECT - standard is based on variadic function of pairs (name, value), but it should be solvable, because our first argument is a array, what is not possible in standard. So ANSI SQL conform implementation of JSON support is still possible in Postgres.

Regards

Pavel