Re: Multiple sets of results from recursive query

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: Greg Sabino Mullane <htamfids(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 19:21:54
Message-ID: CA+i5JwZPFTMQd102mFdi8J3WgcJ4i8TKm9px0uKscWdpNKR37A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Monday, 17 July 2023, Greg Sabino Mullane <htamfids(at)gmail(dot)com> wrote:

> 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?
>>
>
Surely, there must be possible to find all route paths.

Regards, David

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Erik Brandsberg 2023-07-17 19:31:08 Re: Multiple sets of results from recursive query
Previous Message Greg Sabino Mullane 2023-07-17 16:43:09 Re: Multiple sets of results from recursive query