| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | Charles Cui <charles(dot)cui1984(at)gmail(dot)com> |
| Cc: | Aleksander Alekseev <a(dot)alekseev(at)postgrespro(dot)ru>, Aleksandr Parfenov <a(dot)parfenov(at)postgrespro(dot)ru>, Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: json results parsing |
| Date: | 2018-05-31 06:00:28 |
| Message-ID: | 871sdsz81q.fsf@news-spur.riddles.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>>>>> "Charles" == Charles Cui <charles(dot)cui1984(at)gmail(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2018-05-31 12:01:10 | Re: We still claim "cannot begin/end transactions in PL/pgSQL" |
| Previous Message | Michael Paquier | 2018-05-31 03:32:53 | Re: json results parsing |