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(-)
>
>