Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Sabino Mullane
Subject Re: Multiple sets of results from recursive query
Date
Msg-id CAKAnmmKCDuNYxdum7vX=hq6RuLyTcAhoxqsg9ReC3kSMpoP=iQ@mail.gmail.com
Whole thread Raw
In response to Multiple sets of results from recursive query  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: Multiple sets of results from recursive query  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view
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?

Regards,

David

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: best finding all paths with recursive query
Next
From: Shaozhong SHI
Date:
Subject: Re: Multiple sets of results from recursive query