Re: Remove restrictions in recursive query - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Remove restrictions in recursive query
Date
Msg-id 2152313.1743110236@sss.pgh.pa.us
Whole thread Raw
In response to Re: Remove restrictions in recursive query  (Renan Alves Fonseca <renanfonseca@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Non-text mode for pg_dumpall
Next
From: Renan Alves Fonseca
Date:
Subject: Re: Remove restrictions in recursive query