How to use one recursive query if there are may queries in WITH statement ?
I tried with a as ( select 1 as col1 ), RECURSIVE t(n) AS ( VALUES (1) UNION ALL SELECT n+1 FROM t WHERE n < 100 ), c as (select * from t) select * from c but got error syntax error at or near "t" at line RECURSIVE t(n) AS ( recursive b as ( shown in comment with clause is used to create some non recursive queries (a) . After them recursive query is defined (b) and after it there are some other non-recursive queries (c) Using Postgres 9.1 and above. Andrus.