On Thu, Mar 27, 2025 at 9:02 AM Renan Alves Fonseca <renanfons...@gmail.com> wrote:
> So, do we support the ORDER BY in a recursive query or not? > Apparently we do. The "in" recurses. If the answer is yes, I suggest one of the following modifications: > 1. Change the error message to something like "ORDER BY at the top level of > a recursive query is not implemented. HINT: wrap the respective statement > around ()" > The error message is now correct but I'd lose the hint. It assumes a typo and that the query author meant to sort each iteration of the recursive term; when maybe they did wish for the final result of the completed recursive query to then be fed into a sort node and ordered, in which case the parentheses wouldn't help. David J.
