>>>>> "Jitendra" == Jitendra Loyal <jitendra.loyal@gmail.com> writes:
Jitendra> I find that the RECURSIVE can be used only once in a CTE.
RECURSIVE can be specified only once, but it applies to all CTEs at that
level. That is to say, RECURSIVE qualifies the preceding WITH, _not_ the
following CTE.
Note that just specifying RECURSIVE doesn't mean that any CTE is
recursive, it simply changes the name scoping rules such that CTEs _can_
be recursive. (Without it, a CTE's name is not in scope in its own body
so recursion is impossible.)
--
Andrew (irc:RhodiumToad)