Re: json results parsing

2018-05-31 Thread Andrew Gierth
> "Chapman" == Chapman Flack writes: >> To clarify, I think my question is functions like json_each or >> json_object_keys() are >> set returning functions ( >> https://www.postgresql.org/docs/9.5/static/functions-srf.html), >> which means it returns a set of results into a Datum. Chap

Re: json results parsing

2018-05-31 Thread Chapman Flack
On 05/31/18 20:20, Charles Cui wrote: > To clarify, I think my question is functions like json_each or > json_object_keys() are > set returning functions ( > https://www.postgresql.org/docs/9.5/static/functions-srf.html), > which means it returns a set of results into a Datum. Well, it returns one

Re: json results parsing

2018-05-31 Thread Andrew Gierth
> "Charles" == Charles Cui writes: Charles> Thanks you guys for answering my questions, and sorry for confusion. Charles> To clarify, I think my question is functions like json_each or Charles> json_object_keys() are Charles> set returning functions ( Charles> https://www.postgresql.org/

Re: json results parsing

2018-05-31 Thread Charles Cui
Thanks you guys for answering my questions, and sorry for confusion. To clarify, I think my question is functions like json_each or json_object_keys() are set returning functions ( https://www.postgresql.org/docs/9.5/static/functions-srf.html), which means it returns a set of results into a Datum.

Re: json results parsing

2018-05-30 Thread Andrew Gierth
> "Charles" == Charles Cui 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_

Re: json results parsing

2018-05-30 Thread Michael Paquier
On Wed, May 30, 2018 at 08:16:18PM -0700, Charles Cui wrote: > Basically, I want to call these json API inside a plugin, and the return > value for these APIs are Datum. I am wondering how to parse a set of json > results from Datum in postgresql? Seems the helper functions I am aware of > are only

json results parsing

2018-05-30 Thread Charles Cui
Hi mentors and hackers, Found the json API page here https://www.postgresql.org/docs/9.3/static/functions-json.html For some APIs, it returns set of results, for example, json_each(json) and json_object_keys(). Basically, I want to call these json API inside a plugin, and the return value for t