Re: Multiple sets of results from recursive query

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема Re: Multiple sets of results from recursive query
Дата
Msg-id CA+i5JwZPFTMQd102mFdi8J3WgcJ4i8TKm9px0uKscWdpNKR37A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multiple sets of results from recursive query  (Greg Sabino Mullane <htamfids@gmail.com>)
Ответы Re: Multiple sets of results from recursive query  (Erik Brandsberg <erik@heimdalldata.com>)
Список pgsql-sql


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 по дате отправления:

Предыдущее
От: Greg Sabino Mullane
Дата:
Сообщение: Re: Multiple sets of results from recursive query
Следующее
От: Erik Brandsberg
Дата:
Сообщение: Re: Multiple sets of results from recursive query