summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2011-03-26Remove json_send/json_recv and rename json_type/json_type_t to ↵Joey Adams
json_get_type/json_type
2011-01-17Added PostgreSQL 8.4.3 compatibility.Joey Adams
The SearchSysCacheList1 macro was introduced in PostgreSQL 9. Changed a couple tests to cope with formatting discrepancy introduced by PostgreSQL 9 (namely, + characters between newlines).
2011-01-17Fixed UTF-16 surrogate pair calculation to properly handle cases like ↵Joey Adams
"\uD840\uDC00".
2010-08-05Switched all error reporting from elog to ereport.Joey Adams
2010-07-23* JSONPath index subscript no longer extracts chars from strings.Joey Adams
* char() method added to JSONPath for extracting chars from strings. Although index subscripts (those using an integer) extract characters from strings in Stefan Goessner's JSONPath, and although it works that way in JavaScript, I believe it is rather illogical and unexpected in the context of JSONPath, and a poor use of the [] real estate. Because extracting characters from strings can still be useful, I have added a char() method for this. I implemented it now to prevent the supporting code for character extraction from wasting away.
2010-07-23Replaced ginormous json_path testcase with a more trivial one.Joey Adams
The tests no longer take up 2.4 megabytes, and they'll be easier to update whenever semantics are changed (e.g. switching json_path '$..*' from matching breadth-first to depth-first).
2010-07-22Added support for arrays to to_json (but not from_json).Joey Adams
2010-07-22* Added json_set(json, json_path text, json) function.Joey Adams
* Reworked json_node::orig so it can handle replacing the key or value without altering surrounding formatting. * json_encode (C function) is now recursive (its stack usage depends on the depth of input). This was done because json_encode cannot rely on nodes' ->parent fields being trustworthy, as json_replace_value assigns JSON nodes by reference.
2010-07-06* Added json_getJoey Adams
* Affirmed (with a trivial test) that json_path returns its results breadth-first
2010-06-21* Made it so json_path preserves original text.Joey Adams
* Removed the global variable json_escape_unicode and added a parameter for it to the json_encode and json_encode_string C functions.
2010-06-17* Added json_validate(text) function.Joey Adams
* Migrated test strings from json-0.0.2 * Added struct {...} orig; field to struct json_node, but it's not used yet. It will be used to hold pointers to original text.
2010-06-15Added json_condense function and split testcases into 3 files.Joey Adams
2010-06-15Initial implementation of json_path function.Joey Adams
Currently, it re-encodes JSON nodes rather than preserving original text. This is subject to change.
2010-06-14Implemented/tested parser for basic JSONPath(ish) patterns.Joey Adams
2010-06-09Moved everything in /contrib/json along with json.sgml to root directory.Joey Adams
This repository should probably be an honest-to-goodness branch of mainline PostgreSQL. I'm looking into that :-)