Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple sets of results from recursive query - Mailing list pgsql-sql

From Shaozhong SHI
Subject Re: Multiple sets of results from recursive query
Date
Msg-id CA+i5JwZPFTMQd102mFdi8J3WgcJ4i8TKm9px0uKscWdpNKR37A@mail.gmail.com
Whole thread Raw
In response to Re: Multiple sets of results from recursive query  (Greg Sabino Mullane <htamfids@gmail.com>)
Responses Re: Multiple sets of results from recursive query  (Erik Brandsberg <erik@heimdalldata.com>)
List pgsql-sql
Tree view


On Monday, 17 July 2023, Greg Sabino Mullane <htamfids@gmail.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@gmail.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 

pgsql-sql by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Multiple sets of results from recursive query
Next
From: Erik Brandsberg
Date:
Subject: Re: Multiple sets of results from recursive query