In the last year I have created a number of modules providing extra JSON functionality. I'd like to include some of these in release 9.4. Candidates for inclusion are:
json_build: which provides extra functionality for building up non-regualr and arbitrarily complex json, as well as a way of aggregating key value pairs as a json record. See <https://github.com/pgexperts/json_build>
json_object: take a one or two dimensional array of text and turn it into a json object, similar to the way hstore currently does. See <https://bitbucket.org/qooleot/json_object>
json_to_record: turn json into a record or recordset, using the same logic as json_pupolate_record and json_populate_recordset, but inferring the return type from the call instead of from the first argument. See <https://bitbucket.org/qooleot/json_to_record>
json_build is probably the most important in terms of additional functionality.
Both json_build and json_to_record have had to copy non-exposed parts of the internal Json code, which is one of the many reasons I would like to include them, particularly. These extensions have all been created in response to client requirements, so there is a definiite use case for all of them.
If there's agreement on taking these, I will prepare patches and submit them by the 15th.
cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
