Horton
Menu

Re: Remove restrictions in recursive query

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Renan Alves Fonseca <renanfonseca@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, pgsql-hackers@postgresql.org
Date: 2025-03-27T21:17:16Z
Lists: pgsql-hackers 
Renan Alves Fonseca <renanfonseca@gmail.com> writes:
> I'll assume that the silence about allowing GROUP BY means it is not a
> great idea...

Well, you can do grouping, ordering, or whatever else you want to the
result of the recursive WITH in the outer query level.  I don't see
any advantage in allowing an additional level of that inside the WITH.

			regards, tom lane