Hi, in Oracle a recursive CTE unfortunately cannot be marked with the recursive keyword (despite the ANSI standard) and in Postgres it must be marked with "recursive".