On 1st of June, Andrew Dunstan committed patch: Rename jsonb_replace to jsonb_set and allow it to add new values The function is given a fourth parameter, which defaults to true. When this parameter is true, if the last element of the path is ...

On 12th of May, Andrew Dunstan committed patch: Additional functions and operators for jsonb jsonb_pretty(jsonb) produces nicely indented json output. jsonb || jsonb concatenates two jsonb values. jsonb - text removes a key and its associated value from the json jsonb - int removes the ...

Portuguese Brazil Version On 23rd of March, Andrew Dunstan committed patch: Introduce jsonb, a structured format for storing json. The new format accepts exactly the same data as the json type. However, it is stored in a format that does not require reparsing the ...

On 29th of January, Andrew Dunstan committed patch: Add json_array_elements_text function. This was a notable omission from the json functions added in 9.3 and there have been numerous complaints about its absence. Laurence Rowe.

On 28th of January, Andrew Dunstan committed patch: 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() ...

On 29th of March, Andrew Dunstan committed patch: Add new JSON processing functions and parser API. The JSON parser is converted into a recursive descent parser, and exposed for use by other modules such as extensions. The API provides hooks for all the significant ...

On 10th of March, Andrew Dunstan committed patch: JSON generation improvements. This adds the following: json_agg(anyrecord) -> json to_json(any) -> json hstore_to_json(hstore) -> json (also used as a cast) hstore_to_json_loose(hstore) ...

February 12th, 2012 by depesz | Tags: , , | 7 comments »

On 31st of January, Robert Haas committed patch: Like the XML data type, we simply store JSON data as text, after checking that it is valid. More complex operations such as canonicalization and comparison may come later, but this is enough for ...