Re: pgsql: New json functions.

*sigh* forgot to mention that json_to_record() is also included. It
turns a json
argument into whatever record type is expected by the call.


On 01/28/2014 05:55 PM, Andrew Dunstan wrote:
> New json functions.
>
> json_build_array() and json_build_object allow for the construction of
> arbitrarily complex json trees. json_object() turns a one or two
> dimensional array, or two separate arrays, into a json_object of
> name/value pairs, similarly to the hstore() function.
> json_object_agg() aggregates its two arguments into a single json object
> as name value pairs.
>
> Catalog version bumped.
>
> Andrew Dunstan, reviewed by Marko Tiikkaja.
>
> Branch
> ------
> master
>
> Details
> -------
> http://git.postgresql.org/pg/commitdiff/105639900bf83fd3e3eb5b49f49b4d74d6347b9b
>
> Modified Files
> --------------
> doc/src/sgml/func.sgml               |  158 ++++++++++
> src/backend/utils/adt/json.c         |  577 ++++++++++++++++++++++++++++++++--
> src/backend/utils/adt/jsonfuncs.c    |  176 ++++++++---
> src/include/catalog/catversion.h     |    2 +-
> src/include/catalog/pg_aggregate.h   |    1 +
> src/include/catalog/pg_proc.h        |   22 ++
> src/include/utils/json.h             |   13 +
> src/test/regress/expected/json.out   |  126 ++++++++
> src/test/regress/expected/json_1.out |  126 ++++++++
> src/test/regress/sql/json.sql        |   87 +++++
> 10 files changed, 1219 insertions(+), 69 deletions(-)
>
>