MIME-Version: 1.0
References: 
 <CA+i5Jwa_7doLv+PJGKBDeN-K-Dn4kkqp-PxGok5N8UQWwGzzrQ@mail.gmail.com>
In-Reply-To: 
 <CA+i5Jwa_7doLv+PJGKBDeN-K-Dn4kkqp-PxGok5N8UQWwGzzrQ@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Mon, 17 Jul 2023 12:43:09 -0400
Message-ID: 
 <CAKAnmmKCDuNYxdum7vX=hq6RuLyTcAhoxqsg9ReC3kSMpoP=iQ@mail.gmail.com>
Subject: Re: Multiple sets of results from recursive query
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008297d90600b180a2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKAnmmKCDuNYxdum7vX%3Dhq6RuLyTcAhoxqsg9ReC3kSMpoP%3DiQ%40mail.gmail.com>
Precedence: bulk

--0000000000008297d90600b180a2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

What exact problem are you trying to solve? Recursive CTEs return one
row per internal invocation, so they already return a "set" of results, but
you could use arrays or json if you wanted to pack in extra information per
returned row.

On Sun, Jul 16, 2023 at 6:41=E2=80=AFAM Shaozhong SHI <shishaozhong@gmail.c=
om>
wrote:

> Has anyone come across multiple sets of results with recursive query?
>
> How to handle it?
>
> Regards,
>
> David
>

--0000000000008297d90600b180a2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">What exact problem are you trying to solve? Recursive CTEs=
 return one row=C2=A0per internal invocation, so they already return a &quo=
t;set&quot; of results, but you could use arrays or json if you wanted to p=
ack in extra information per returned row.</div><br><div class=3D"gmail_quo=
te"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, Jul 16, 2023 at 6:41=E2=
=80=AFAM Shaozhong SHI &lt;<a href=3D"mailto:shishaozhong@gmail.com">shisha=
ozhong@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex"><div dir=3D"ltr">Has anyone come across multiple sets of re=
sults with recursive query?<div><br></div><div>How to handle it?</div><div>=
<br></div><div>Regards,</div><div><br></div><div>David</div></div>
</blockquote></div>

--0000000000008297d90600b180a2--