Re: json results parsing

>>>>> "Charles" == Charles Cui <charles.cui1984@gmail.com> writes:

 Charles> Hi mentors and hackers,
 Charles>    Found the json API page here
 Charles> https://www.postgresql.org/docs/9.3/static/functions-json.html

 Charles> For some APIs, it returns set of results, for example,
 Charles> json_each(json) and json_object_keys().

 Charles> Basically, I want to call these json API inside a plugin,

If you want to process the whole of a json (not jsonb) value inside a
plugin, then maybe pg_parse_json is what you should be looking at rather
than the SQL-callable functions.

For jsonb, there's an iterator interface (JsonbIteratorInit/JsonbIteratorNext)

--
Andrew (irc:RhodiumToad)