Re: Multiple sets of results from recursive query

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Multiple sets of results from recursive query
Date: 2023-07-17 16:43:09
Message-ID: CAKAnmmKCDuNYxdum7vX=hq6RuLyTcAhoxqsg9ReC3kSMpoP=iQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 AM Shaozhong SHI <shishaozhong(at)gmail(dot)com>
wrote:

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2023-07-17 19:21:54 Re: Multiple sets of results from recursive query
Previous Message Shaozhong SHI 2023-07-16 17:22:21 best finding all paths with recursive query