>>>>> "Jitendra" == Jitendra Loyal <jitendra.loyal@xxxxxxxxx> 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)
