Re: json results parsing

From: Chapman Flack <chap(at)anastigmatix(dot)net>
To: Charles Cui <charles(dot)cui1984(at)gmail(dot)com>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
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-06-01 01:57:59
Message-ID: 5B10A827.8060600@anastigmatix.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 result row as a Datum (either a single value
or a tuple) each time it is called, until the whole set has been
returned. The process is described here

https://www.postgresql.org/docs/9.5/static/xfunc-c.html#XFUNC-C-RETURN-SET

(though that description is from the point of view of the set-returning
function being called, not the point of view of its caller).

-Chap

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gierth 2018-06-01 02:16:53 Re: json results parsing
Previous Message Andrew Gierth 2018-06-01 01:56:24 Re: json results parsing